InfoPath Dev

I have a bunch of data in my Sharepoint List (combination of let's say 10 different fields).  I put two dropdowns on my form, and want to load only the rows that the user selects into a repeating table.

 So for example, customers.  The user selects State and City, I want the repeating table to populate information ONLY for customers in the selected State and City.

Thoughts, ideas, opinions?

Thanks!

Chris

Well - when you say you want the repeating table to populate - is your control bound to your secondary data source? Or are you trying to copy the repeating data into your main data source?

If this is a control bound to your secondary data source, you can use conditions to hide rows. If this is an InfoPath 2010 form, your list data connection will have query fields - you can set them to the values selected in the drop downs and then execute a query that will only return the items you want. But if you are trying to copy the data into your main data source, there will be other issues - namely that IP won't do this OOB.