Newbie Questions

Re: Automatically adding multiple lines of data to a repeating table from access table

oneoldhockeyguy — Wed, 06 Oct 2010 17:28:53 GMT

Thanks Jimmy - I'll give it a try!

Re: Automatically adding multiple lines of data to a repeating table from access table

Jimmy — Wed, 06 Oct 2010 17:19:46 GMT

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.

Automatically adding multiple lines of data to a repeating table from access table

oneoldhockeyguy — Wed, 06 Oct 2010 16:18:41 GMT

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