Use this selection to define how a table is related to the case table. For example, you might join the table to the case table.
The left-hand pane lists the schemas that you can access. To add a table, click on it in the left-hand pane and click > to move the table to the right-hand pane.
First specify how the tables are related by selecting at least one case table column in the case table and identifying the columns in the related table to which it is related.
Next indicate the relationship type: One-to-One is the default.
Finally, indicate which columns from the related tables to include. The default is to include all columns.
Click OK to return to the related tables dialog.
Once you define a relationship, you can edit it by clicking the Edit link.
Copyright © 2005, Oracle. All rights reserved.