Working with related tables and files > Working with the relationships graph
 
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. Choose File menu > Manage > Database.
2. In the Manage Database dialog box, click the Relationships tab.
Relationships graph showing related tables and a text note
Relationships graph buttons
 
Click
To
Add table button
Add a table to the relationships graph
Add relationship button
Create a relationship
Duplicate table button
Duplicate selected tables (and relationships) and selected notes
Edit button
Edit the selected relationship, table occurrence, or text note in the relationships graph
Delete button
Delete selected relationships, or table occurrences, or text notes in the relationships graph
Align vertical button
Align the left edges, centers, or right edges of the selected objects
Align horizontal button
Align the top edges, centers, or bottom edges of the selected objects
Distribute objects button
Distribute the selected objects horizontally or vertically
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
Change the color of selected tables or notes in the relationships graph
Select object button
Choose the object selection cursor (default cursor)
Add text note button
Add a text note to the relationships graph
Magnification cursor button
Choose the magnification cursor
Reduction cursor button
Choose the view reduction cursor
Reduce magnification of the relationships graph button
Adjust the magnification of the relationships graph to view all tables
Select related tables button
Select related tables 1-away or select tables with the same source table
Reduce or increase view button
Manually reduce or increase the view of the relationships graph, up to 400%
Show page breaks button
Show page breaks
Show Print Setup or Page Setup dialog box button
Show the Print Setup (Windows) or Page Setup (OS X) dialog box
Print
Print the relationships graph across multiple pages, or resized to fit on one page
Other relationships graph elements
 
Element
Action
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
Toggles the display of the text note. Click once to collapse to the first line of text. Click again to return the text note to its original size.
Match field is available to many records
Indicates that the match field is available to match many records
Match field can match a single record
Indicates that the match field is intended to match a single record, such as an auto-entered value
Unindexed match field indicator
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
Displays the relational operator, or Multi-criteria indicator for a multi-criteria relationship
Related topics 
About the relationships graph
About relationships
Creating a solution
About the types of relationships
About match fields for relationships
Editing ODBC data sources