I am creating Infopath 2010 browser based form. I have a drop-down list which is pulling data from SharePoint 2010 list. The real challenge is that I need to show and hide this drop-down control based upon an Amount ($) field. Here are the rules I am looking to accomplish:
- If the Amount field is < $250,000 show this drop-down list
- If the Amount field is between $250,000-$500,000 show this drop-down list
So as you see, we are applying both these rules to the same drop down list. How do I accomplish this without creating a duplicate of this drop-down list and applying seperate rules?
Any suggestions?