Using graphic relationship display

You can use the GRAPHIC primary command to receive a graphic display of related tables. The graph includes both AR and RI relationships and both parent and dependent tables for any table involved in the relationship.

The following figure shows a graphical relationship display for the DEPT table. The current table is highlighted. You can scroll up/down and left/right to display information that is not visible.

If a table has an asterisk (*) next to it, it displays somewhere else in the display; that is, it is related to more than one table. If a table displays in the graph more than once, its dependent tables only appear the first time.

Graphical Relationship Display

Receiving an Option List

From a Graphical Relationship Display, you can tab to any table name and press Enter to receive an Option List (see the following figure). It provides a list of options that you can perform for the selected table.

The items that display in the list are dependent on the selected table.

Option List for Table EMP

• Display Relationship Information: Displays the Relationship Information window. See Relationship Information Window.
• Go to Dependent Detail. Positions the cursor at the first occurrence of the table in the graph. This option will not appear if at the first occurrence of a table.
• Go to Dependent of table name. Positions the cursor at the first occurrence of the dependent of the specified table name. This option will not appear if there are no dependents for the selected table.