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?