InfoPath Dev

Hi JY, You can have your data in an access db and make a data connection to your db. That will work fine. There are other ways of doing it as well. Here is a link from MS where they do it using webservices for browser enabled forms http://blogs.msdn.com/infopath/archive/2006/10/12/cascading-dropdowns-in-browser-forms.aspx You can also have all ...

 I had something similar. My drop downs were populated by a secondary data source and the filter was working fine. But when I saved the form and opened it again, only the selected value was there. To get around this problem, I used a rule and the trigger for it was loading of the form. You have the option of adding rules when you load up the ...

   Try putting the rule on the @Product_Estimated_Sell_Amt. For example, Condition: When  @Product_Estimated_Sell_Amt > 0 Action: Set fields value: @ActualThirdPartyBudget = @Product_Estimated_Sell_Amt This way the  field @ActualThirdPartyBudget will always change as long as the @Product_Estimated_Sell_Amt value is more ...

There is a option of adding rules when the form open. Tools-->FormOptions-->OpenAndSave Any rule that you put in there will be calculated everytime, you open the form. Even when you open the saved forms as well. So the rule you are using to calculate the field, use the same rule here as well. Hope it helps.

Hi JY, You can use the filtering data option in InfoPath. But I am not sure if its going to work for manually entered values. In this case you will probably have to write some code to do it. There is another way you can do it. If you keep all your values in xml files and add them as resources, you will be able to filter the data. This is ...