InfoPath Dev

Can someone help please? Do you still think this is even possible?

Sure, I'll remember to post XPath when possible from now on. Here they are: xdXDocument:GetDOM("Products")/dfs:myFields/dfs:dataFields/d:IV00101/@ITEMDESC[../@ITEMNMBR = xdXDocument:get-DOM()/my:RMA/my:productsInvolved/my:prodID] xdXDocument:GetDOM("Products")/dfs:myFields/dfs:dataFields/d:IV00101/@ITEMNMBR[../@ITEMDESC ...

Hi, I have two (main) fields in a repeating table. They are Product Number and Product Name. Their values are taken from my sql db. I want to keep their selections synchronized. So if someone selects a product number, it automatically fills in its corresponding name. And vice-versa: if someone chooses a product name, the product number ...