InfoPath Dev

Hi All,

This one is a though one....

i have a reapiting table with 2 dropdown list box in it.

the first dropdown gets the data from an access table filtered by a text box outside the reapiting section.

the second dropdown list gets the data from an access table filtered by the first dropdown list.

the problem starts when i duplicate the section.

the first dropdown list is full (first line is blank and the client can choose a value from the list) - this is OK

but, (and this is the problem) the second dropdown list still carry the values from the first section.

the dropdown list get the data from the "Look up values in a data connection to a database, web service, file, or sharepiont library or list" option.

can i get the values to the second dropdown list filterd by the first dropdown list choosen value in another way?

Thank you for your help,

Eli Moscovich.

 Hi Eli Moscovich,

You have add one more filter (using ‘And’ not ‘Or’) to second drop down list, that is first drop down list box is not equal to blank.

To clear the second drop down list box:

You have to add one rule to first drop down list box. And rule is you have to clear the second drop down list box when first drop down list box is empty.

Hope this helps you

Dear Shiva.

this dont solve the problem becuse the first line is empty but if i press the dropdown list box i can see the values.

Hi elimosco,

Try this Blog, you will get the result.

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