Preventing InfoPath from showing same value in each row (repeating table)

Question

I have a repeating table showing data from an external list. It is connected with further (hidden) columns in the list but the form only shows a few (3) columns from the (around) 8. First column is a drop down list and when I select an item it shows me the same value in each row even if selecting 3 different items. It seems the system pulls only one row data per group.

Can you please advise a formula or rule to be used?

One row down:

Reference: How to display a complete SharePoint list row in InfoPath form

Answer 1

You have to add rule on dropdown control. When dropdown item changed, Rule will fire and set it to related hours and Price textbox.

Add action: Set field's value, Add hours textbox and set value with following steps. Same process for Price textbox.

1. Click on Fx button
2. Click on Insert Field or Group..
3. Select secondary data source (Your list) from above dropdown
4. Select Hours field
5. Click on Filter button
6. Set condition like Item(Secondary data source) = Item(Main source Dropdown)
7. Save it

Answer 2

In Rules, use current() function so that is compared to the current row's field. Example:

current()/../my:FieldNameForCompare