I have an Access 2016 table that contains the following:
PriID - key field
PriFirstName
PriLastName
SecFirstName
SecLastName
This contains Name & spouse or partner
I have another table:
AddressID - key field
Address
City
State
ZipCode
The two have a one-to-many relationship.
No problems here.
I need to create another table that will allow me to:
Have a one-to-many relationship with the Names table (above).
This new table needs to properly identify Associations to either the primary name or the spouse/partner name.
Both names could have associations assigned but, they would not necessarily be the same.
Associations could be something like Volunteer, Officer, Board Member.
Each name COULD have one or more or NO associations.
How can I design the Names and Associations tables to allow the proper relationship for this?