InfoPath Repeating Table Lookup control on SharePoint List
Posted by ken zheng on February 1, 2012
It is common to get more values from the dropdown list. For example, when user select the product, more product details are retrieved.
Just type current() in the Formula
You need manually modify the XPATH, “current()” function should fix this problem.
xdXDocument:GetDOM("Active Products (BCS)")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:SubSBU[../d:PRDNO = current()]
Reference:
http://rawatsumit.blogspot.com.au/2009/10/infopath-repeating-table-lookup-control.html