Creating relations
Close all design window windows before starting
Use Tools, Relationships or the icon
Click on each table in the Show Table Window to place them in the work area
Click on the field of the one table and paste it on top of the same field in the many table
- Access will open a relation dialog, be sure to select enforce referencial integrity
- repeat this step as necessary
- you will see the relations as in this example