Fig. 56: Referential Integrity
To specify relationships between the table columns, the window "Referential integrity can be called by double clicking at the black line (s. fig. 5).
Fig. 56: Referential Integrity
The button opens the window Link properties (s. fig. 6).
The control fields with referential integrity, refresh transfer to detail field and delete transfer to detail record allows more association properties.
| with referential integrity | There is referential integrity between the selected columns |
| refresh transfer to detail field | A table value is updated whenever the related value in the other table changes |
| delete transfer to detail record | A table value is deleted whenever the related value in the other table is deleted |
If the control field "with referential integrity" is activated, so the design of the table connection is changed (s. fig. 58 ).
Referential Integrity
