Linking a column to a foreign key constraint

You can link a column to an existing primary key, foreign key, or unique key constraint.

  1. Select System > Agency Personalization > Schema Manager.
  2. In the Enhancement Product Families tree, browse to the Constraints node for the table definition containing the column that you want to link the constraint to.
  3. Click the Constraints node.
  4. Enable editing in the grid and select the constraint that you want to link the column to.
  5. Under Linked Columns, click Add above the grid.
  6. Specify the column that you want to link the constraint to in the Column field.
    Click the popup button to the right of the Column field, select a column from the list, and click Select. The list includes all columns from the current table.
  7. Specify the table that the link references in the Referenced Table field.
    Click the popup button to the right of the Referenced Table field, browse to the table that you want to select from the list of Infor product families that is displayed, and click Select.
  8. Specify the column within the referenced table that you want the linked column to reference in the Referenced Column field.
    Click the popup button to the right of the Column field, select a column from the list that is displayed, and click Select. The list includes the primary key column for the selected table.
  9. Click Save to save the link.
    Infor Public Sector shows the link in the Linked Columns grid.
  10. Click Save to save the constraint.
    Infor Public Sector saves the changes to the constraint. The column that you specified from the current table now references the column that you specified in the referenced table. For example, an employee ID foreign key constraint may tell an employee ID column to reference the employee ID column in the EMPLOYEE table.