Invantive Estate

Referential Constraints

This screen lets you record and referential rules change. Open screen in browser Open Form

A referential constraint is a connection between the data in two tables.

The registration of referential constraints is typically an activity for application developers. See the warning under Application Development.

Referential Constraints Screen

The meaning of the entry fields is:

Name	The name of the referential constraint.
Role	The role of the referential constraint in case there are multiple referential constraints between two tables.
Sort Order	A numeric value used for sorting the referential constraints when they are shown in a list box in a screen. This functionality is not supported yet.
From
Application	The application of which the from column is part of.
Table	The name of the table of which the from column is part of.
Column	The name of the column.
To
Application	The application of which the to column is part of.
Table	The name of the table of which the to column is part of.
Column	The name of the to column.
Create	Checked if the referential constraint needs to be included in the database.
Show	Checked if the referential constraint needs to be displayed in the database. This functionality is not supported yet.
Documentation	Documentation of the referential constraint.