Adding a reference to a destination table

  1. To add a reference, right click Reference or click New. The Add New Reference window is displayed.
  2. Select the reference type.
  3. 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.
  4. 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.
  5. Click Save.