- Select the Relationships item from the Tools menu.
- We want to work with all four tables in our database (eventually), so highlight all four tables and click the Add button.
- Click the Close button and you’ll be presented with a database diagram showing the database’s four tables
- Click on the CustomerID field in the Customers table and, while holding the mouse button down, drag the pointer to the CustomerID field in the Orders table and release the mouse button.
- Verify that the two fields listed in the Edit Relationships pop-up window are correct. They should point to the CustomerID fields of the Customers and Orders tables.
- Check the Enforce Referential Integrity and Cascade Update Related Fields boxes in the Edit Relationships window and click the Create button
- You’ll see the link between tables appear in the diagram, with the numeral 1 next to the Customers table and the infinity symbol next to the Orders table, symbolizing a one-to-many relationship (the default for Access).
In our next article, we’ll learn how to add data to the database using Access forms.