Defining Relationships
The Table Editor Relationships tab displays the table’s relationships to parent tables.
Relationships
The list on the left is the Relationships Overview that lists all the relationships from the table to its parents. Use this list to create a new relationship, delete an existing relationship, or select a relationship to view or edit its composition.
Each relationship in this list is represented by the name of the parent table being related to.
Selecting a relationship displays the relationship’s column pairings to the parent table. These are displayed in the Relationship Column Pairs grid on the right.
Relationship Column Pairs
The Relationship Column Pairs grid, on the right, displays a list of child table foreign key to parent table primary key column pairs. These pairs define the columns that participate in the relationship.
The child table foreign key columns are listed in the grid’s first column. The parent table’s primary key columns are listed in the grid’s second column.
Each foreign key/primary key column pair must have matching column type and length.
The following operations can be performed in this list:
- Change the from column by selecting a column from the combo list. The from columns that are displayed in the list are filtered to columns that do not already participate in a relationship.
- Change the to column by selecting a column from the combo list. If a from column has already been selected for this row, then the to columns that are displayed in the list are filtered to columns that match the type and length of the from column.
- Add a new column pair to the relationship by clicking the Add Column Pair button on the toolbar or simply going to the bottom row of the list and beginning to select columns.
- Remove a column pair from the relationship by selecting it in the list and clicking the Delete Column Pair button on the toolbar.
Toolbars
Add Relationship
Click this button to add a new relationship to a parent table. This activates the Add a Relationship dialog. Use this dialog to select a parent table for the relationship.
Keyboard shortcut: (Ctrl+A)
Delete Relationship
Click this button to delete the currently selected relationship.
Keyboard shortcut: (Ctrl+D)
Add Column Pair
Click this button to add a new child foreign key/parent primary key column pair to the currently selected relationship.
Keyboard shortcut: (Ctrl+A)
Delete Column Pair
Click this button to delete the currently selected child foreign key/parent primary key column pair from the currently selected relationship.
Keyboard shortcut: (Ctrl+D)