Re: Refresh the drop down lists in repeating sections

smate — Fri, 24 Apr 2009 14:54:12 GMT

Thank you, The approach worked for me.

Re: Refresh the drop down lists in repeating sections

swathip — Fri, 24 Apr 2009 05:23:26 GMT

Hi,

Once go through the below link.

http://www.infopathdev.com/blogs/greg/archive/2005/07/14/Create-a-Repeating-Cascading-List-from-a-Flat-Data-Source.aspx

Refresh the drop down lists in repeating sections

smate — Fri, 24 Apr 2009 03:51:15 GMT

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.

Data Connections

Re: Refresh the drop down lists in repeating sections

Re: Refresh the drop down lists in repeating sections

Re: Refresh the drop down lists in repeating sections

Refresh the drop down lists in repeating sections