Is there any way to create a list from within a table.
For example, I have a field in a table that has fields for the First Name, the second name and a field that joins the 2 to create a full name and then fields for a secondary contact, first, last, full name, and then a field that joins both the 1st and 2nd contact
What i want to be able to do is create a list that lists these.
1st contacts full name
2nd contacts full name
the 1st & 2nd contacts full name.
From there i want to be able to select one of the above.
Is this possible?