User manual

Chapter 4 | Working with related tables and files 119
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 > Manage > Database.
2. In the Manage 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.
4. Edit tables and match fields for the relationship.
To Do this
Change a match field Select the new match field and click Change.
Add a match field Select the new match field and click Add.
Change the relational
operator
Select a new relational operator from the list and click Change.
See “Relationships using comparative operators” on page 115.
Duplicate a pair of
relationship criteria
Select the paired criteria from the list in the middle part of the dialog box and click
Duplicate.
Delete a pair of relationship
criteria
Select the paired criteria from the list in the middle part of the dialog box and click
Delete.
Select options for the
tables in the relationship
Select the relational
operator