Adding a reference to a destination table
-
To add a reference, right click
Reference or click
New. The Add New
Reference window is displayed.
-
Select the reference type.
-
Select the target table or the table that should be referenced.
For example, if you want to add a reference for the table PO_LINE, you may want
to reference the table VENDOR.
-
Select the target column on which the tables will be joined. In
the example above, you would join the tables on the CDM_VENDOR_ID column to
obtain the vendor name.
-
Click
Save.