I an using three drop downs in the repeating section. All drop downs are retrieving the values from a secondary data source, the secondary data source is a sharepoint list. Field A (drop down #1) is not dymanically populating data. I am using the sharepoint list so that is will be easy to maintain. Field B (drop down #2) is filtered based on the main value selected in the Field A (this is achieved by using the sharepoint data connection) and similarly Field C (drop down #3) is filtered based on the main value selected in the Field B (this is also achieved by using the sharepoint data connection).
My Problem: All three fields are in repeating section. for Section 1: When I select 'x' in Field A (values for Field A - x,y,z) , Field B (Drop Down #2) filters the related values ( x has 1,2,3,4 related values) and similarly when I select '1' in Field B , Field C (drop down #3) filters the related values (1 has aa, ab, ac, ad). Having said this when I create a section 2. and select 'y' in Field A the drop down values in Filed B are getting combined (e.g the values for 'x' and 'y' are shown)
How do I create the drop downs for a repeating section unique where I have dependancy for he fileds? I am very new to InfoPath and would like to aviod code. I am using InfoPath 2003 and VB script for few functions.