The Table Relations virtual table (ID 2000000141) contains information about table relations for all fields in Microsoft Dynamics NAV non-system tables.
The following table describes the fields in the Table Relations virtual table.
| Field | Description |
|---|---|
TableId | ID of table that contains the field with the relation. |
FieldNo | Specifies the field number of the field with the relation. |
RelationNo | Specifies the identification number of the relation. |
ConditionNo | Specifies the identification number of the condition. |
RelatedTableId | Specifies the ID of related table. |
RelatedFieldNo | Specifies the field number of related field. |
ConditionType | Specifies the type of condition for the relation. It can contain the following values CONST or FILTER. |
ConditionFieldNo | Specifies the field number that is involved in the condition. |
ConditionValue | Specifies the condition value. |
TestTableRelation | Specifies whether to test the relation. |
ValidateTableRelation | Specifies whether to validate the relation. |