General Foreign Key Properties


The basic parameters of a foreign key are set using the Foreign Key panel's General tab.


Foreign Key Panel's General Tab

To define the basic parameters for a foreign key, first select the child table and the parent table.

Then select a single column from both the child and parent table's column list to specify the column pair that will be used in the foreign key. Click Add Column Pair.

If this foreign key has multiple column pairs repeat the previous step for each additional pair.

Once the column pairs have been specified you may use the Auto Name button to automatically generate a name for the foreign key. The parameters for autonaming are edited using Preferences.


See also:

Creating Foreign Keys
Detailed Foreign Key Properties
Advanced Foreign Key Properties