Working with the relationships graph
Use the relationships graph to create, change, and view the relationships in your database file.
By default, the relationships graph displays all of the tables in your current database file. You can add tables from other files (including external ODBC data sources), add more than one occurrence of the same table to the graph, or remove tables from the graph using the buttons described below.
To access the relationships graph:
1.
With the database open, choose File menu > Manage > Database.
2.
The relationships graph appears.
Relationships graph showing related tables and a text note
Relationships graph buttons
 
Add table button
Add relationship button
Duplicate table button
Edit button
Delete button
Align vertical button
Align horizontal button
Distribute objects button
Resize button
Resize the selected objects to the smallest width, smallest height, smallest width and height, largest width, largest height, largest width and height
Color palette button
Select object button
Add text note button
Magnification cursor button
Reduction cursor button
Reduce magnification of the relationships graph button
Select related tables button
Select related tables 1-away or select tables with the same source table
Reduce or increase view button
Show page breaks button
Show Print Setup or Page Setup dialog box button
Other relationships graph elements
 
Displays source table and source file names
Displays the names of the source table and source file as you move the pointer over the table header
Toggles table display
Toggles the display of the table. 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.
Toggle text note display
Match field is available to many records
Match field can match a single record
Indicates that the join cannot be made. For example, a match field is missing or is an unindexed field (such as an unstored calculated field or a global field), or the table closest to the indicator is missing or unavailable.
Relational operator indicator
Related topics 
About the relationships graph
About relationships
About planning a database
About the types of relationships
About match fields for relationships
Relationships graph keyboard shortcuts (Windows)
Relationships graph keyboard shortcuts (Mac OS)
Editing ODBC data sources
Topics in this section
Creating relationships
Changing relationships
Adding tables to the relationships graph
Selecting related tables in the relationships graph
Duplicating tables in the relationships graph
Resizing tables in the relationships graph
Aligning tables in the relationships graph
Adding text notes to the relationships graph