A validation list is a list of acceptable values that can be entered at a field. Use this procedure to create and export a multi-line UDF validation list to the key fields in user-defined tables (UDTs).
Before You Begin
To export a UDF validation list
-
Select Custom Office Main menu > User-Defined Field and Table Maintenance.
-
Select the table to create the UDF in, and click the Edit Fields button.
-
In the User-Defined Fields window, click the Add button. For more information, see User-Defined Fields - Fields.
-
In the Add Field window:
-
Enter the field name and description. For more information, see Add Field - Fields.
-
Select Manual Entry and click OK. A second Add Field window appears.
-
In the second Add Field window:
-
In the Control Type field, select Multi-Line. For more information, see Add Field/Edit Field - Fields.
-
In the Data Type field, select String.
-
In the Maximum Length field, type the maximum field length. The maximum length must be the same as the UDT key field length.
-
Click the Validation tab, and select List.
-
In the List field, type the validation list to create and export.
-
Select User-Defined Table, and click OK.
-
When you are prompted to export the validation list, click Yes.
-
In the User-Defined Fields window, click OK.
-
When you are prompted to update the data dictionary and UDF data files, click OK.
The validation list is exported to the UDTs and the UDF is created.
