https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/45810.aspxThu, 13 Aug 2009 14:09:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:45810StuPittwood0https://www.infopathdev.com:443/forums/thread/45810.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=45810<p>Ok, I think I&#39;m a bit closer ...... looks like I need to use the current() function?</p> <p>how would I work that into the following statement?</p> <p>xdXDocument:GetDOM(&quot;Transport_Fleet&quot;)/dfs:myFields/dfs:dataFields/d:Transport_Fleet/@Serial[starts-with(<a href="mailto:../@Fleet_No">../@Fleet_No</a>, xdXDocument:get-DOM()/my:myFields/my:group13/my:Truck/my:Equipment_ID)]</p> <p>Regards</p> <p>Stu</p> <p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/45805.aspxThu, 13 Aug 2009 10:18:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:45805StuPittwood0https://www.infopathdev.com:443/forums/thread/45805.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=45805<p>Hi all,</p> <p>I have a repeating table in an Infopath Form (2007) &amp; a data connection to a SQL database.&nbsp; The repeating table comprises of Make, Model, ID, Serial Number Fields.&nbsp; The user needs to be able to enter a serial number, tab to the next field &amp; have the other details populated from the data connection to SQL.&nbsp; Now, this is working for the first item in the repeating table.&nbsp; If I add a second row, it populates the fields in the 2nd row with the same data as the 1st.</p> <p>&nbsp;Any help appreciated.</p> <p>Stu&nbsp;</p> <p>&nbsp;</p>