Microsoft Access 2010 Bible

Chapter 3: Designing Bulletproof Databases

121

FIGURE 3.15

You enforce referential integrity in the Edit Relationships dialog box.

6. Click the Create button.

Access draws a line between the tables displayed in the Relationships window, indicating
the type of relationship. In Figure 3.16, the 1 symbol indicates that tblBookOrders5 is
the “one” side of the relationship while the infinity symbol (∞) designates tblBookOr-
derDetails as the “many” side.

FIGURE 3.16

A one-to-many relationship between tblBookOrders5 and tblBookOrderDetails

Primary key Foreign key

One-sided table Many-sided table