What Is Required to Create a Relationship Between Two Tables in Microsoft Access?
Creating relationships between two Microsoft Access tables "links" the two tables together. Before you can create the link between the two tables, you need some criteria to create the link.
Other People Are Reading
-
Function
-
Creating a relationship links two tables, so you can query both tables using one query command. This saves resources, and it reduces the amount of time it takes for the database to return records.
Requirements
-
To link two tables, you must have a primary key in one table, and a foreign key on the other table. For instance, a customer number in the customer table is a primary key, and the customer number in the orders table is the foreign key. These two values match, so the relationship is created.
-
Features
-
You identify the primary and foreign key in Access using the table designer. A small key icon identifies the primary key in the main table. The foreign key is created when you establish the relationship. A line is drawn from the primary key to the foreign key when you link two tables.
-
