InfoPath Dev

I read about 30 articles on this site pertaining to this but was unable to solve my issue so I am asking for assistance if possible.

I have a repeating table with 4 columns.

In Column 1 is a text box linked via data connection to our Active Directory web service. It is linked to the attribute windowsUserId

Column 4 contains a button, when on click, retreives the firstName and lastName of the windowsUserId entered in column 1 and displays them in text fields in columns 2 and 3. All of this works perfectly.

When I insert another row, the button click updates all rows based upon whats in column 1 of the current row. How/where do I use current() in my form so that the button in each row only updates columns 2 and 3 of that row based off the information from column 1 of that row.

 The app generated code on my button event is:

XDocument.DOM.setProperty "SelectionNamespaces", "xmlns:my=""http://schemas.microsoft.com/office/infopath/2003/myXSD/2008-05-14T19:26:17"""

Any assistance with this would be very appreciated, thanks.

On your button rule where you reference windowsUserID you would want the current function so that it get the current row value not the first value.

The syntax is often tricky, especially in 2003, where you can not extract the xpath easily.

Look at examples but you want to reference the repeating node with the current function.

count(../preceding-sibling::my:RowNode) + 1

This doesn't work and is as close as I have gotten. Any idea's how to change this to get the current row value? Thanks.