Issue Syncing Lists with InfoPath

EArgen — Mon, 19 May 2014 16:23:52 GMT

Hello Everyone,

I'm new to SharePoint and to InfoPath, so this might be an obvious answer but I just can't seem to figure it out. I am using the newest SharePoint and InfoPath 2013.

I have two different lists:

List A

EMP_ID, FirstName, LastName

List B

Address_ID, Address, City, State, ZIP, EMP_IDFK

I have a data connection for both of those lists separately.

When I have repeating sections for each of those fields in one long row, the data does not sync up between the rows. For Example:

FirstName -- Last Name -- Address -- City -- State

A1 A1 B1 B1 B1

A2 A2 B2 B2 B2

A3 A3 B3 B3 B3

However, if the second table doesn't have information in it for someone, that row disappears.

FirstName -- Last Name -- Address -- City -- State

A1 A1 B1 B1 B1

A2 A2 B2 B2 B2

A3 A3 Missing!

Worse yet, if a fourth person is added, their address info is where the last person's address info should be:

FirstName -- Last Name -- Address -- City -- State

A1 A1 B1 B1 B1

A2 A2 B2 B2 B2

A3 A3 B4 B4 B4

A4 A4

Am I setting up my lists incorrectly? Am I missing something obvious in InfoPath?

SharePoint Integration

Issue Syncing Lists with InfoPath