InfoPath Dev

Hello,

I am new to Infopath and am not a techie.  I have created a form where added repeating table as shown below:

Departments        Usernames        Roles

row 1

What I am trying to do is to auto-fill the fields from an Access table as shown below:

ID       Departments        Usernames        Roles

row 1            1        BioMed                 Phil                   Admin 

row 2            2        OR                      Dr. Phil               User 

However, when I preview the form, all I get is this:

Departments        Usernames        Roles

row 1           BioMed                 Phil                   Admin 

row 2           BioMed                 Phil                   Admin 

The second, third, etc... line in the repeating table is always the first line of the Access table.

What I was hoping to achieve is the 2^nd line of the repeating table would match the second line of the Access table.

How can I make this work?  HELP!!!!

Thank you in advance.

Phil

This is the technique we use and suggest for copying data from one repeating group to another:

http://www.infopathdev.com/files/folders/qrules/entry58577.aspx

The above document involves a SharePoint-based solution, but I believe the method described on pages 12 through 25 applies just as well to your situation.