Create a Table of Choices

When you click Table while displaying an alphanumeric field for which you selected the Table validation field, you can enter choices users can select from a drop-down list.

The program displays the file name, sequence number of the user field and previously defined values in the table:

Field	Description
Cd	The code for the choice displayed in the drop-down list when the field is prompted
Description	A description of the code

Choose the appropriate options:

To	Do This
Add a code	Click Add. See step 2.
Delete the selected code	Click Delete.
Copy the selected code	Click Copy. See Copy.
Display or change the code	Click Select or double-click the line. See step 2.
Print the list of codes	Click Print. See Print.
Return to the user field	Click OK. See Create User Fields.

Enter or change data in these fields:

Field Name	Type / Max Length	Action / Description
File	Display	The name of the file that contains the user field
Sequence number	Display	The sequence number of the user field
Code	Required 25 alphanumeric	Enter a choice to be displayed when the user field is maintained. Consider the order you want the choices listed in the drop-down. See Display Order. You cannot change this field once a code is added.
Description	Optional 25 alphanumeric	Enter a description for the code. The description displays to the right of the field when an entry is selected.

Choose the appropriate options:

To	Do This
Change a field	Move the cursor to the field, make changes and click Apply to accept changes or click Cancel to reject changes.
Delete the selected code	Click Delete.
Copy the selected code	Click Copy. See Copy.
Display or change the code	Click Select or double-click the line. See step 2.
Accept the data and return to the list of codes	Click OK. See step 1. If you are adding codes, the program for another code. Click OK again to return to the list of codes.

Display Order

Choices are displayed in alphanumeric sequence in a drop-down list when the user field is maintained. To make selecting choices most efficient, make sure the ones you expect to be selected most often are at the top of the list.

For example:

If you enter these choices	The list displays in this order
2 Raw material	1 Purchased component
Finished good	2 Raw material
In-house prototype	Assembled component
Customer prototype	Customer prototype
1 Purchased component	Finished good
Assembled component	In-house prototype