Using the Relationship Editing Mode

Use Relationship Editing Mode to create, modify, delete, or override model joins.

You can access Relationship Editing Mode in two ways:

  • If Model Design Accelerator detects a potential issue, the Model Warning window displays. The option Manually re-draw the joins between tables activates the functionality of Relationship Editing Mode from the Model Warning view.
  • You can double-click a query subject in the Model Accelerator workspace to access the Query Subject Diagram. From there, click Enter Relationship Creation Mode.

Procedure

  1. Select two tables that you want to join.

    If you cannot create a direct join between two tables, use intermediate tables. To add intermediate tables, drag the tables from the Explorer Tree onto the Query Subject Diagram. Then, create the required joins by linking the tables through the intermediate tables.

    Tip: An intermediate table has a dashed outline.

  2. Click the Create a Model Relationship icon create model relationship icon.

    The Modify the Relationship dialog box is displayed. A new join line is displayed.

  3. Select a column from each table to create the new relationship.
  4. Select the appropriate relationship cardinality.
  5. Click OK twice to return to the Model Accelerator workspace.

    If your action results in an invalid model, the Model Warning view displays.

Results

Alternatively, from Relationship Editing Mode, you can select the columns you wish to join and then click the Create a Model Relationship icon create model relationship icon. The Modify the Relationship dialog box displays with the join displayed between the selected columns.