Download Wiley Microsoft Access Data Analysis: Unleashing the Analytical Power of Access

Access Basics
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 connecting 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.
23