Working with the relationships graph

Contents > 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.	With the database open, choose File menu > Manage > Database.

2.	In the Manage Database dialog box, click the Relationships tab.

The relationships graph appears.

The relationships graph.

Relationships graph buttons

Select

To

This button adds a table to the relationships graph.

Add a table to the relationships graph

This button opens the Edit Relationship dialog box. Use it to create a new relationship.

Create a relationship

This button duplicates tables, (and relationships) and selected notes.

Duplicate selected tables (and relationships) and selected notes

This button opens the Edit Relationship dialog box. Use it to edit an existing relationship, table occurrence or text note in the relationships graph.

Edit an existing relationship, table occurrence, or text note in the relationships graph

This button opens deletes a relationship or table occurrence in the relationships graph.

Delete a relationship, or table occurrence, or text note in the relationships graph

This button aligns the left edges, centers, or right edges of selected objects in the relationships graph.

Align the left edges, centers, or right edges of the selected objects

This button aligns the top edges, centers, or bottom edges of selected objects in the relationships graph.

Align the top edges, centers, or bottom edges of the selected objects

This button distributes the selected objects horizontally or vertically in the relationships graph.

Distribute the selected objects horizontally or vertically

This button resizes the selected objects.

Resize the selected objects to the smallest width, smallest height, smallest width and height, largest width, largest height, largest width and height

This button changes the color of selected tables in the relationships graph.

Change the color of selected tables or notes in the relationships graph

The object selection cursor.

Choose the object selection cursor (default cursor)

This button adds a text note to the relationships graph.

Add a text note to the relationships graph

The magnification cursor.

Choose the magnification cursor

The view reduction cursor.

Choose the view reduction cursor

This button reduces the magnification of the relationships graph to view all tables.

Reduce the magnification of the relationships graph to view all tables

This button selects related tables with the same source table.

Select related tables 1-away or select tables with the same source table

Type a number to reduce or increase the view of the relationships graph, up to 100%.

Manually reduce or increase the view of the relationships graph

Show page breaks for printing the relationships graph.

Show page breaks

Show the Print Setup (Windows) or Page setup (Mac OS) dialog box.

Show Print Setup (Windows) or Page Setup (Mac OS) dialog box

Other relationships graph elements

Use

To

Display the names of the source table and source file by moving the pointer table header.

Display the names of the source table and source file by moving the pointer over the table header

Toggle the display of the table in the relationships graph.

Toggle 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 the display of the text note.

Toggle 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.

This symbol indicates that a match field can match many records.

Indicates that the match field is available to match many records

This symbol indicates that a 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

Relational operator icon

Displays the relational operator, or The bowtie symbol represents a multi-criteria relationship.

The bowtie symbol represents a multi-criteria relationship.

for a multi-criteria relationship

Related topics

About the relationships graph

About relationships

About planning a database

About the types of relationships

About match fields for relationships

Creating relationships

Relationships graph keyboard shortcuts (Windows)

Relationships graph keyboard shortcuts (Mac OS)

Editing ODBC data sources

Contents > Working with related tables and files > Working with the relationships graph