InfoPath form Services - implementing a Master-Detail on the web

REF:http://www.sharepoint-tips.com/2007/01/infopath-form-services-implementing.html

If you ever tried publishing a form to the web using infopath form services, you probably know that one compatibility issue you will have is with master-detail (also known as "cascading dropdowns") fields.

Master-detail basically means when you have two fields (usualy dropdown boxes) and you want the options in the second field to change based on the choice the user made in the first field.

For example, I have a dropdown called "States", and a dropdown calles "Cities". Now I want when the user chooses a state, to only show cities within the chosen state.
This is easy to do in infopath - just connect the dropdowns with a little configuration. But when you try to publish the form to a web form, it will tell you that the master-detail will simply not work in the web form. It's not supported.


To the rescue!

http://www.sharepoint-tips.com/2007/01/infopath-form-services-implementing.html


NOTE: This works but you need to have your security setting to Fully Trusted!!!!