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.
This article is Part 2 of the Microsoft Access tutorial.
Here’s what’s included in this article:
To create a relationship in MySQL Workbench:
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:
This will create the relationship. You will see the tables in the Relationship tab with lines depicting the relationship between the tables.