Table Relations Virtual Table
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. |