Creating a relationship
When you create a Relationship, the Table from which the relationship starts is known as the parent or master Table. The Table where the relationship ends is known as the child or detail Table. You can add one to many or one to one Relationships between Tables on the Table Relationships Diagram.
To create a one to many relationship:
1. On the Table Relationships Diagram tab, click the One to Many Relationship button.
2. Click the parent Table, and then click the child Table.
You can show or hide the relationship name through the Relationship's View Options.
To create a one to one relationship:
1. On the Table Relationships Diagram tab, click the One to One Relationship button.
2. Click the parent Table, and then click the child Table.
You can show or hide the relationship name through the Relationship's View Options.