Add a virtual foreign key relationship so that you can cross-reference table. You create virtual foreign keys on a child table that link back to the parent table.
The column in both the parent and child table must follow these rules:
-
Numbers must be the same size and sign (for example positive).
-
String arrays do not need match in length.
-
Character arrays must use the same character sets.
Multiple relationships can be added or removed with the Add and Delete buttons. Changes do not take effect until you click the OK button.
Table Name
The parent table name for the selected table in the Content tab of the Subclient Properties dialog box.
Dependent Table Name
A list of all the dependent (child) tables for the selected table.
Foreign Key
Use this key to define the relationship between the tables. The following are available:
-
RESTRICT
-
CASCADE
-
SET NULL
-
NO ACTION
Column
This box lists all the columns contained in the Dependent (child) table.
Column
This box lists all the columns contained in the Table (parent) table.
Add
Click this button to add the relationship between the selected Columns. Changes do not take effect until you click the OK button.
Delete
Select a Foreign Key from the Existing Foreign Keys box and click this button to remove the relationship. Changes do not take effect until you click the OK button.
Existing Foreign Keys
This box lists all foreign key relationships that exist. Select the Virtual check box to add a virtual foreign key.