FORMS validates a field after interpretation and each time the field changes value during verification. If a validation fails, the field receives an error status and FORMS prompts you to manually correct the field value before the field and the form it belongs to are complete and ready for further processing.
You can use a table, or tables, to validate a field if there are a limited number of acceptable values for the field. Examples would be when the value of a product code field must exist in a table of valid product codes, or when the value from a clothing size field must exist in a table of available sizes.
There are two ways to do this:
Specify a validation table. This way is appropriate if all acceptable values for the field can be listed in a table. FORMS searches for the interpreted value in the table. If the value is not found in the table, then the field receives Validation error status and is presented to you in Verify.
Validating field values using a connection table: Overview. This way is appropriate when the acceptable values for one field depend on the value of another field.