Sets whether to validate a table relationship.
Applies To
-
Fields
Property Value
Yes if you want to validate the table relationship; otherwise, No. The default is Yes.
Remarks
For fields, use this property to determine whether to validate the user's entry based on the information already in the table set up through the TableRelation Property property.
If you want to let users enter any value without validating the entry, then choose No. For example, on the item card, you can specify the vendor that you typically purchase the item from. Set this property to No to allow users to select a vendor that may not already be in the Vendor table.
If you set the ValidateTableRelation property to No, then you should also set the TestTableRelation property to No. Otherwise, a database test on the field relations in a database may fail.