B
Brian
I use a City-State reference table in my genealogy database for three fields
in another table - the birth, death, and primary residence locations for each
person.
The way I originally defined the relationships in the Relationships Window
was by using the Show Table option and inserting the table three times.
Access shows the tables as City-State_1, City-State_2, City-State_3. Is there
a better way to establish the relationships?
I miss being able to expand the records in my original table with the "+"
button. Evidently setting up the relationships as I did does not allow to
view related records anymore without a query being performed.
in another table - the birth, death, and primary residence locations for each
person.
The way I originally defined the relationships in the Relationships Window
was by using the Show Table option and inserting the table three times.
Access shows the tables as City-State_1, City-State_2, City-State_3. Is there
a better way to establish the relationships?
I miss being able to expand the records in my original table with the "+"
button. Evidently setting up the relationships as I did does not allow to
view related records anymore without a query being performed.