How to Set Table Relationships in Access 2013

If you want to build a table relationship in Access 2013, you must first open the Relationships window. You do that by following these steps:

1

Click the Database Tools tab on the Ribbon.

The Relationships group appears on the Ribbon.

2

From the Relationships group, click the Relationships button.

The Relationships window appears.

3

Choose Show Table from the Ribbon’s Relationships group. (If you don’t see the Relationships group, select the Design tab on the Ribbon.)

The Show Table dialog box appears, listing the tables in the current database file.

4

For each pair of tables you want in the relationship, click the table and then click Add.

In the big Relationships workspace, a little window lists the fields in the selected table. As you add tables to the layout, a separate window appears for each table. You can see these windows to the left of the Show Table dialog box.

Repeat Step 2 for each pair of tables you want to relate. If one of the tables in the pair is already present (due to an existing relationship it has with another table), you don’t have to add it again.

5

After you finish adding tables, click the Close button.

Decide which two tables you want to relate.

Since the one-to-many relationship is the most common, these instructions pertain to it. The two tables in a one-to-many relationship are designated as fulfilling either the Parent or Child roles.

6

Put the mouse pointer on the field you want to relate in the parent table and hold down the left mouse button.

Usually the field you want to relate in the parent table is the primary key.

7

While holding down the left mouse button, drag the mouse pointer from the parent field to the child table.

A plus sign appears at the base of the mouse pointer.

8

Point to the related field in the child table and release the mouse button.

The Edit Relationships dialog box appears, detailing the soon-to-be relationship.

9

In the Edit Relationships dialog box, select the Enforce Referential Integrity option.

Double-check that your field names are the correct ones and then click Create.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com