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.