Create a Relationship

You can create a relationship from the main window or the Relationship Editor.

From the Main Window

To create a relationship:

  1. In the main window, select New from the File menu.
  2. Select Relationship from the Definitions submenu to open the Select Relationship's Parent Table dialog.
  3. Optional – Specify a Pattern to limit the list of tables based on your criteria and click Refresh.
  4. Double-click the desired parent table name to open the Select Relationship's Child Table dialog.
  5. Double-click the desired child table name to open the Relationship Editor.
  6. To add columns to the Relationship List, select Parent Columns (or Child Columns) from the Tools menu and drag the column name to the appropriate grid cell in the Relationship Editor.
  7. Modify the parent or child column expressions, as needed.
  8. Select Save from the File menu to open the Save the Relationship Definition dialog.
  9. In the Constraint box, specify a unique relationship name and then click Save.

From the Relationship Editor

To create a relationship:

  1. In the main window, select Relationship from the Definitions menu to open the Relationship Editor and last edited relationship.
  2. Your next step depends on your purpose:
    • To create a new relationship, select New from the File menu in the Relationship Editor to open the Select a Parent Table dialog. Select a parent table to open the Select a Child Table dialog and then select a child table. The names of the selected tables appear in the Relationship Editor. You can edit the relationship, as needed.
    • To create a new relationship modeled on an existing one, open the desired relationship and select Save As from the File menu in the Relationship Editor.
    • To create and store a copy of the active relationship and continue editing, select Save Copy As from the File menu in the Relationship Editor.

These steps are the minimum required to create a relationship. Because similar methods are used to create and modify a relationship, refer to Using the Editor for more information.