I have two SharePoint lists, Person, and Address. The Person list has name-related columns (First, Middle, Last), and a unique identifier column called PersonID. The Address list has address-related columns (Street 1, Street 2, City, State, Zip), and a PersonID column as well. Each person may have more than one address. So the two SharePoint lists may look like this:
PERSON LIST
PersonID First Last
10001 John Doe
10002 Jane Dow
ADDRESS LIST
PersonID Street 1 City
10001 123 Main Anytown
10001 235 A Street Anothertown
10002 467 B Street Anytown
I have created a form in the Person list that displays the person information, and their related address information. However, it only shows the first row of related address information. For example, when I pull up John Doe's form, it only displays 123 Main, Anytown. I need it to also show the other rows of related address information, 235 A Street, Anothertown for John Doe for example.
How can I accomplish this?