The Foreign Keys tab is divided into two
sections, one with a list of foreign keys and one with various
dialogs for foreign key settings.
To add a foreign key, click the + (plus) button below the foreign key list. You will be prompted to name the new foreign key, and it is then be added to the list.
To drop a foreign key, select the foreign key and click the - (minus) button below the foreign key list. The foreign key is then dropped from the foreign key list.
You can modify the name of the foreign key, its ON
DELETE, and its ON UPDATE actions
using the dialogs provided in the Foreign Key
Settings section of the tab.
To establish a foreign key relationship, choose a table from the Ref. Table drop-down list. The columns that can be referenced as foreign keys are listed in the area below, and you can drag a column from the column editor to the Column section to the left of the column you wish to reference.
