Fig. 31: Foreign key
To use Referential Integrity, there must be created foreign keys for the table. These can be created, edited and deleted on the editor page Foreign key.
Hint:This editor page will notbe available, when the table is static.
| The following entries are available: | |
|---|---|
| Foreign key | List of the existing foreign keys |
| Add foreign key | Adds a new foreign key to the table |
| Delete foreign key | Deletes the selected foreign key |
| Key name | The name of the selected foreign key |
| Foreign key column | The table column of the selected foreign key |
| Primary key table name | The table name on their primary key the selected foreign key referred |
| Tabellenauswahl | Allows to select a table with the primary key by the Document Selection dialog |
| Primärschlüsselspalte | Defines the column, wich contains the primary key |
| Update records automatically | When activated, on every change of the primary key value, the values with the corresponding foreign key will also be updated |
| Delete records automatically | When activated, every deletion in the primary table implicates the deltion of the record data records with the according foreign key in the reference table |
Hint:Foreign keys will not be supported by every database system, e.g. MySQL.
Table Editor