InfoPath Dev

Is there a way to change the drop down list source between two different external lookup based on the value in a text box? For example let say a user types fruit in a text box and clicks out and now that drop down list shows Apple, Grape, Orange. The user then types Vegetable in that same text box and now the drop list shows Carrots, Peas, ...

It is a SP List that I altered the InfoPath for.  I think I figured out a solution.  I think Multi-selection boxes are useless in a list library and only useful in a form library.  I ended up using a LOOKUP column and ticked the box allowing multiples selections.  Now my form works as well the data entry from datasheet view ...

I think the choices are connected to the control, not the field.... but I could be wrong. Is this a SharePoint list form? Or a 'normal' InfoPath form?

I have included a Multiple-Selection List Box in an InfoPath form for a List Library.  If I right click on the control I can see that the "Get choices from an external source" is selected and my external source is showing.    But if I right click on the field in the Fields list, my external choices are gone, ...

So happy I could help, and I'm glad you have it working the way you need it to! Congrats!

The form is finished. Oh wow, what an adventure. I learned so much. You truly are awesomesauce, Hilary. Thank you, thank you, a million times thank you! :)

This is a setting in the data connection. Walk through the data connection again, and on the last (or next to the last, I forget which) there is a checkbox indicating if the query should run when the form opens - deselect that. Then in your rules, set the query field & execute the query to get back just the stuff you want. :)

 Ok, I think this is it, if I can get this figured out, I'm all set! Again, Hilary, there aren't enough thank-yous in the universe for all the help you've given. In doing searches I've seen countless replies from you to other frustrated developers. You really are a special person and I hope that you will be ...

 Disregard. I've been looking at this so long I'm missing stuff. Was linking to the query fields, not data. <sheepish grin>

Back for (what I hope) is my last question: When I create the secondary (receive) data connection that links to my SharePoint Library, by default the Groups it creates aren't repeating ones, and it doesn't allow me to make any of the Groups repeating, so I am unable to use a repeating table like you did in your ...