Using the Manager, select the Standard tab of the Field dialog.
In Table type, select which kind of table you want to use for field validation:
Internal table. (See also Using tables to validate field values.)
Text file. Click for specifications.
ODBC connection. Click for specifications. Fill in Data source, as well.
In the Table name box, type the name of the table that must contain the field’s value in order for the field to pass the validation. If the table is an internal table or ODBC database, type only its name. If it is a text file, type the complete path and name.
Optional: Select Store table internally to have the table you indicate for validation stored in main storage while Interpret is running. (If the table is in an ODBC database, only the handle is saved in main storage.) This can speed up its operation, especially if you are using an internal table for active validation or an ODBC table for either normal or active validation.
Optional: Select Show candidates in Verify to make values from the table you specified available during verification. (Exception.) (Show me what it looks like.) In this case, text files rather than internal tables are preferable when tables are large (more than 500 entries).
Important: If no Table name is specified, it does not matter which table type is selected, because the function is not activated.