Cascading drop downs - changing one changes all!

[Andrew Walman]

Hello all,

I have an Infopath form with a repeating table. In this table are two
dropdown lists. The value of the first list changes the values available for
the second list. Both lists are populated by a web service. The problem I
have is that when a user has filled out a form, when they change values for
the first dropdown in any particular row, this is affecting the available
values in the second dropdown for all the existing rows in the table -
screwing up the entire form.

I need to only update the values in the dropdowns for the current row -
whats the best way to do this?

Thanks

 

[S.Y.M. Wong-A-Ton]

The filter you're using is probably incorrect. You need to either use the
current() function to identify the current row to filter and fill the second
drop-down, or you have to use code to identify the value in the same row to
filter and fill the second drop-down.