InfoPath Dev

Hi, I've searched high and low and can't seem to figure this out. First let me describe what I'm trying to do. I have a form that is going to be used as a tracking system. The form saves to a document library but also sends some data elements from a repeating table to a customer list. What I need to do is update the custom list records if the user modifies the form. I've already set up the caml template and it will work if I hard code the record ID into the caml template so what I need to do now is identify the record ID in of the repeating table node. I added the custom list as a secondary data source and pulled the ID and a tracking number field that's unique. When the form opens the idea is to have the ID field populated if it exists in the custom list. Here is the xpath that works but it populates all fields with the ID from the first row.



xdXDocument:GetDOM("IncomingCapture")/dfs:myFields/dfs:dataFields/dfs:IncomingCapture/@ID[../@TRACKNUM = xdXDocument:get-DOM()/my:myFields/my:Waste_Line_Items/my:TRACKNUM]

I've tried adding current() every which way I could but it still doesn't work. If anyone knows the answer, I would be eternally greatful for the help. Thanks!

Hey Shaun,

My intuition is telling me that we need to find the correct place to call current() - but since you said you've tried all of these combinations I don't know what else to do. Below is my stab at it, but if it doesn't work I don't know what else to do. Maybe if you made a simple sample form and e-mailed it I could figure it out. Otherwise, you can purchase some support hours and we can do Skype + Desktop sharing to figure out the problem.

http://www.qdabra.com/products.asp?cat=12

xdXDocument:GetDOM("IncomingCapture")/dfs:myFields/dfs:dataFields/dfs:IncomingCapture/@ID[../@TRACKNUM = current()/my:TRACKNUM]