update repeating table on form load

SusanP — Fri, 27 Sep 2013 23:09:17 GMT

My InfoPath 2010 web-enabled form includes a data connection to a SharePoint list, which provides a group of choices. As user makes one or more selections, one at a time, a row in a repeating table is populated.

On subsequent loads of the form, I want to re-query that SP list to update the a single column in that repeating table for each row (all at once). Was hoping I could use rules with ID = current() in form load, but all rows are updating with the data from the last row’s record ID. My statement in form load looks like this:

xdXDocument:GetDOM("Security Roles")
/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Approvers/pc:Person/pc:AccountId
[../../../d:ID = current()/my:backOfficeSection/my:fmsFunctions/my:fmsFunction/my:fmsRoleTitle]

Any ideas? I'm unable to use code. Thank you!

Newbie Questions

update repeating table on form load