This article is Part 2 of the Microsoft Access tutorial.
Here’s what’s included in this article:
- Design View.
- Add field properties to a field.
- Add two more tables (for the relationship)
- Set up a relationship between three tables.
To create a relationship in MySQL Workbench:
- Create a database model (either create a new model or reverse engineer an existing database)
- Viewing the database model, double click on the first table of the relationship
- The bottom pane will open with the table details. Click on the Foreign Keys tab
- In the left pane, select the foreign key field and referenced table
- In the middle pane, select the foreign column and referenced (primary key) column
- In the right pane, set any Update/Delete actions you’d like to occur when a primary key record is updated or deleted
The relationship is now established. Repeat steps 4 to 6 for any other foreign key columns in that table.
To create a relationship in Access 2013 or 2016:
- While viewing a table in Design view, and ensuring that the DESIGN tab is selected, click Relationships from the Ribbon
- A Show Table dialog will appear with a list of tables and queries. Select the tables (and/or queries) that you wish to create a relationship between, and close the dialog
- The Relationships tab will appear with the selected tables. Click and drag a field on top of a field in another table to initiate a relationship.
- The Edit Relationships dialog will pop up containing both fields. Make any adjustments and click OK
This will create the relationship. You will see the tables in the Relationship tab with lines depicting the relationship between the tables.