Datasheet

Figure 1-13 A one-to-many relationship between tables can be identified by the infinity
symbol on the line connecting the tables.
Creating and editing relationships
In the Relationships window, you can add tables by right-clicking the display
and selecting Show Table. Once your tables have been added, relationships
can be established by dragging one field from one table to a field in another
table. Figure 1-14 shows the Edit Relationships dialog box that then appears.
You can also edit an existing relationship by right-clicking the line connect-
ing the two tables.
Figure 1-14 Based on the use of primary keys and
foreign keys, the Edit Relationships dialog box attempts
to guess the kind of relationship you want to establish.
Access Basics 23
05_59978X ch01.qxp 12/1/05 7:46 PM Page 23