Linking to an arbitrary table

For the ICFM tables that do not have foreign keys, use this method to link to an arbitrary table. Tables that do not include foreign keys are CFFACT.REFERENCE KEY, CFFACT.RESOLVED ENTITY REF, and SPATIAL.SPATIAL_LOCATION. For example, if you want to display a business object on a map, follow this procedure to link to SPATIAL.SPATIAL_LOCATION.

Procedure

To link to an arbitrary table:

  1. In the Detection Navigator, double-click the .cflo file that defines the business object to be edited.
  2. Right-click in the Associated tables view and click Link with arbitrary table. The Add Arbitrary Link Table window is displayed.
  3. Select an existing table that is linked to the business object.
  4. Select the column that is key to the new table.
  5. Select the new table that you want to link to the business object. Then select the column in the new table that matches the column in the existing table.
  6. Optional: Specify which stereotype to use to filter the new table.
  7. Click OK to save your changes.