A foreign key specifies that the values in a column (or a group of columns) must match the values appearing in some row of another table. We say this maintains the referential integrity between two related tables.

Foreign Keys are managed on the Foreign Keys tab of the Table Designer. Just simply click/double-click a foreign key field for editing. A right-click displays the popup menu or using the toolbar below, allowing you to create new, edit and delete the selected foreign key field.

Add Foreign Key

To add a foreign key

• Open the table in the Table Designer.
• Open the Foreign Keys tab.
• Right-click and select the Add Foreign Key from the popup menu or click the Add Foreign Key from the toolbar.
• Edit foreign key properties.

Edit Foreign Key

To edit a foreign key

• Open the table in the Table Designer.
• Open the Foreign Keys tab.
• Just simply click/double-click on the foreign key to edit.

Delete Foreign Key

To delete a foreign key

• Open the table in the Table Designer.
• Open the Foreign Keys tab.
• Right-click on the foreign key to delete and select the Delete Foreign Key from the popup menu or click the Delete Foreign Key from the toolbar.
• Confirm deleting in the dialog window.

See also:
Setting Foreign Key Name and Table Fields
Setting On Delete and On Update Actions

Related topic:
Foreign Keys Data Selection