Using the Foreign Keys Tab

When you define a foreign key, you limit values that the users can enter for an attribute. Foreign keys are used to connect values to value sets in a Infor Document Management system.

  1. Select the Foreign Keys tab.
  2. Click Add to open the Define Foreign Key page/window.
  3. Enter the Constraint name for the tie between the attributes.
  4. Select Restrict as the Update rule so that the target cannot be updated. If you select No Action, the target can be updated.
  5. Select any of the following, Restrict, Cascade, No action, or Set null as the Delete rule.
    1. If you select Restrict, you cannot delete the target because it is referenced by the source.
    2. If you select Cascade, the source will be deleted when the target is deleted.
    3. If you select No action, deleting the target has no affect on the source.
    4. If you select Set null, deleting the target sets the source to null.
  6. Select the source item type or child component from the Select Source Component list.
  7. Select the Target item type or table. If you select an external table, enter the schema and name of the target table. For a DB2 Content Manager item type target, the source and target attributes appear in the Source attributes and Target attributes lists. Ensure that target attributes must be Require and Unique.
  8. Select attributes and click the Add button to pair the source and target attributes. For an external table target, the source attributes appear in the Source attributes list. Select an attribute and type a column name in the Target column field and click the Add button to pair the source attribute and target column.
  9. Select the Show target data as drop down in client box to have the target information displayed in the eClient. This can be ignored for the Infor Document Management system. Value sets are always displayed as drop down menus.
  10. Click OK.