How to Create Relationships Between Tables in Access
Once you begin to understand the concept of relational databases, the process of actually linking the tables in a database is rather simple.
Make sure you keep these rules in mind when you link to tables together.
You need to display the Relationships window in order to view and create relationships between tables.
Whenever you link a primary key from one table to a field from another table, you create a foreign key.
Referential integrity helps you avoid “orphan” records and maintains database accuracy.
The two tables are now linked, indicated by the line linking the two related fields.