Microsoft Office Professional 2010 Step by Step eBook

Creating Relationships Between Tables 817

8. In the Customers field list, click CustomerID, and drag it down and over
   CustomerID in the Orders field list, releasing the mouse button when two
   little boxes, one containing a plus sign, appear below the pointer.
   The Edit Relationships dialog box opens.

At the bottom of the dialog box, Access indicates that this will be a one-to-many relationship.

9. Select the Enforce Referential Integrity check box, and then click Create.

Access creates the link between the primary key in the Customers table and the

foreign key in the Orders table, and a line now connects the two field lists on

the Relationships page.

The symbols at each end of the line indicate that each Customer ID value appears only once

in the Customers table but can appear many times in the Orders table.