InfoPath Dev

Hi all,

I have a repeating table in an Infopath Form (2007) & a data connection to a SQL database.  The repeating table comprises of Make, Model, ID, Serial Number Fields.  The user needs to be able to enter a serial number, tab to the next field & have the other details populated from the data connection to SQL.  Now, this is working for the first item in the repeating table.  If I add a second row, it populates the fields in the 2nd row with the same data as the 1st.

 Any help appreciated.

Stu 

Ok, I think I'm a bit closer ...... looks like I need to use the current() function?

how would I work that into the following statement?

xdXDocument:GetDOM("Transport_Fleet")/dfs:myFields/dfs:dataFields/d:Transport_Fleet/@Serial[starts-with(../@Fleet_No, xdXDocument:get-DOM()/my:myFields/my:group13/my:Truck/my:Equipment_ID)]

Regards

Stu