InfoPath Dev

I have a form infopath 2010 posted to a sharepoint 2010 server.

In the form I have a repeating table let's say I have 2 fields - Customer and Amount

I have a rule that when the Customer field changes (Rule- run when field changes) the amount is queried from a secondary source (a sharepoint list) and displayed.

This works great for the first Customer, when I "Insert and additional Customer" in my repeating table and enter a new Customer Name, I get the same Amount as the one above and with each subsequent addition.

Seems like it is not running the query for the items below the initial Customer entry.

Any help would be appreciated.

So - are you querying the list when the customer field changes? Setting the query Customer field to the Customer and then executing the query? I'd drag my secondary data source onto the form so I could see it (temporarily, easy enough to delete it when you are done) and see what the data I'm getting back is - if you are returning all the data, you may need to add a filter to your rule that set's the amount - that the customer in the secondary data source is equal to the current node (if the rule is on the customer in the main data source, for example) - hope that makes sense...