Question
You plan to create a table to hold client data.
You have the following data integrity requirements:
- Lookups into other records must be established.
- Validate if a record exists in a destination record.
You need to select the table field property to use for each requirement.
Which table field property should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
For Establish lookups into other records, choose TableRelation, the field property that sets up a lookup into another table. DataClassification and ExternalAccess deal with data handling and external access, and ValidateTableRelation only controls checking of a relation that already exists.
For Validate if a record exists, choose ValidateTableRelation, which determines whether a user's entry is checked against the data in the related table, so an entry with no match causes a validation error. CalcFormula defines how a FlowField is calculated, and Access and AccessByPermission concern who can reach the field.
