https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/10816.aspxWed, 10 Jan 2007 09:48:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:10816Patrick Halstead0https://www.infopathdev.com:443/forums/thread/10816.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=10816Hi Shaun,<br /><br />Sorry for the huge delay over the holidays responding to this. Current() is one of the most difficult functions to figure out. We do this all the time, but it's not easy. Good luck and if you need more assistance feel free to buy some hands-on time from us. We have blocks available in our store.<br /><br />Why not just use SQL? SharePoint is not good at tying lists and forms together. You can do it but you get in trouble because transactions aren't atomic and if you have dependencies you can end up with refIDs that point to dead ends. <br /><br />Regards!https://www.infopathdev.com:443/forums/thread/5980.aspxFri, 22 Dec 2006 22:14:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5980shaun.nieves0https://www.infopathdev.com:443/forums/thread/5980.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5980Hi, 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. <br /><br /><pre><br />xdXDocument:GetDOM("IncomingCapture")/dfs:myFields/dfs:dataFields/dfs:IncomingCapture/@ID[../@TRACKNUM = xdXDocument:get-DOM()/my:myFields/my:Waste_Line_Items/my:TRACKNUM]<br /><br />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!<br /></pre>