Select a Relationship to Edit

You can select an Optim™ relationship for editing or browse a database relationship from the main window or the Relationship Editor. The most common method is explained first.

From the Main Window

To select a relationship:

  1. In the main window, select Open from the File menu to display the Open (object selection) dialog. (See Using the Open Dialog for more information on the Open dialog.)
  2. Double-click Relationship to expand the identifier list.
  3. Double-click the desired DB Alias to display a list of relationships.
  4. Optional – Specify a Pattern to limit the list based on your criteria and click Refresh.
  5. Double-click the desired explicit or generic relationship to open the Relationship Editor.
Note: To select the last relationship you edited, select Relationship from the Definitions menu in the main window to open the Relationship Editor and the last edited relationship.

From the Relationship Editor

To select a different relationship:

  1. In the Relationship Editor, select Open from the File menu to display the Open a Relationship dialog. (See Using the Open Dialog for more information on the Open dialog.)
  2. Double-click the desired DB Alias to display a list of relationships.
  3. Optional – Specify a Pattern to limit the list based on your criteria and click Refresh.
  4. Optional – Select a Show pattern for option to display a specific type of relationship.
  5. Optional – Select the Relationships Related to Table check box and enter a table name to retrieve a list of relationships that include the table. To limit the list further, select the Show Only Directly Related Tables check box.
  6. Double-click the desired relationship to open the Relationship Editor.