Table Relations Virtual Table

The Table Relations virtual table (ID 2000000141) contains information about table relations for all fields in 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.

See Also

Virtual Tables