User manual

Working with related tables and files 69
5. Repeat step 4 for each match field you intend to use in this
relationship.
For more information about match fields, see “About match fields
for relationships” on page 64.
6. Click OK to save your changes and close the relationships graph.
Changing relationships
After you have created a relationship, you can add or change match
fields, change relational operators, and set options for creating,
deleting, and sorting related records.
To change a relationship:
1. With the database open, choose File menu > Define > Database.
2. In the Define Database dialog box, click the Relationships tab.
3. In the relationships graph, locate the relationship to edit, and
double-click the indicator line between the related tables to open the
Edit Relationship dialog box.
Or, you can select the relationship in the graph and click to open
the Edit Relationship dialog box.
Click to add a table
Click to create a relationship
Click to change an existing relationship
Click to delete a relationship
Use these buttons to enlarge or
reduce the view of the graph
Use these buttons to change the
alignment of selected tables
Move the pointer over the
table header to display the
names of the source table
and source file
Click once to collapse
all but the match fields.
Click again to collapse
all but the table name.
Click again to return the
table to its original size
Click to show page breaks
Click to display the Print
Setup (Windows) or Page
Setup (Mac OS) dialog box
Click to change the color
of selected tables