InfoPath Dev

Dear all at this wonderful forum,

I have created two dropdowns in my InfoPath form. 

At these dropdowns, I can select values from the column 'Solution' and the column 'Sol. Responsible' - information taken from a Sharepoint site.  

What I would like to do:

I would like if I in some way only need to choose one of the values/information, meaning e.g. when one have selected from the first dropdown (the solution), the next dropdown (the solution responsible) is automatically filled-out.

However, it doesn't have to be by using two dropdowns if there is a smarter way of doing it? Maybe you only need to use one dropdown and have information from both the columns shown there, or maybe you can suggest an even better solution?

I look very much forward to hearing from all of you experts :-)

Thank you so much in advance!

Br,

Christopher

Hi, Christopher - you could just set your Sol. Responsible with a rule on the Solution field. You need to add a rule to your main data source Solution field that will set your main data source Sol. Responsible field. When you select the value you'll be setting Sol. Responsible to, you need to click the filter data button and add a filter in order to get back the "right" Sol. Responsible for the selected Solution. If you need a hand, feel free to attach your form under the Options tab in a reply.

Hi Hilary, Thank you very much for your answer :-) I tried out what you explained, but unfortunately I didn't succeed. I have attached my form and will be so happy if you could help! Br, Christopher

Hey, Christopher - I'm going to grab your email address from your user info (I have moderator access) and will send you an email w/ your form attached, since you had concerns about stored data. :) Let me know if you don't get it.