InfoPath Dev

Hi
I have a repeating table.
In each row, I have 3 dropdownlists.
With the selection of this 3 values, a 4th Dropdown will be filled (Access database)

Now I have the following problem:
Everything is alright with the first row.
In the second row, when I have selected the 3 values of the dropdownlists, I get the list of row 1 and row 2 together in the 4th dropdownlist.

Does anybody know to solve this problem. I need only the values to the current row.

Thanks a lot.
Best regards.
Philippe

You need to research the current() function. There are many posts on how to use it here in the forums and in the blogs.

Hi Clay
Thanks a lot for your advice
I have found the solution in the blog of Greg Collins "Create a Repeating Cascadind List from a Hierarchical Data Source"

the solution is very simple: Formula for populating the dropdownlist:
current()/my:myfield
and it works perfectly
Best regards.
Philippe