- How to model one-to-one relationship?
- How do you show a one-to-many relationship?
- How do you display the relationships window?
How to model one-to-one relationship?
Primary Key as Foreign Key
One way to implement a one-to-one relationship in a database is to use the same primary key in both tables. Rows with the same value in the primary key are related. In this example, France is a country with the id 1 and its capital city is in the table capital under id 1.
How do you show a one-to-many relationship?
In a one-to-many relationship, one record in a table can be associated with one or more records in another table. For example, each customer can have many sales orders. In this example the primary key field in the Customers table, Customer ID, is designed to contain unique values.
How do you display the relationships window?
The Relationships window lets you define relationship between items stored in multiple Access tables. It is available by clicking Database Tools > Relationships.