InfoPath Dev

For example, I have an SQL 2005 database with a table called states. Within that table two columns, all 50 states in one and their counties in the next (this may or may not be the best way of going about this). On my form, I want the user to be able to select their state in one dropdown and then have another dropdown update itself with the counties that only apply for the state that was chosen. If anyone knows how to easily get this setup or can point me to a post where this has already been answered please advise!

Oh, and this is a browser based form, so I am not sure filters will work?
 

Thanks in advance! 

SPD32177
 

You would need to setup a data connection for the data.

Then you create a field for state and country

You add a dropdown control on state that use the data connection.

Then you put a rule on the dropdown that sets country to the country from your DC with a filter state in your DC equals state in your form.

You may want to check out the Qdabra Database Accelerator Suite Version 2.1 - Developer if you are working with SQL