Codelists provide a shorthand method for entering values from a codelist for a coded column in the displayed row. You can set the Select/Edit toggle field from the Edit Code dialog box to Select. Any codelist value you select becomes the value for the current codelisted column.
From the Edit / Review dialog box, you can also select a coded column in the displayed row and key in #n# where n equals the code slot number for the value you want to enter. For example, the following codelist is for the face_type column in the diffuser table.
If you select the Process Query button for a table with a coded column, any row without a valid value for the coded column displays with the value
********* INVALID CODE **********
You have three ways to enter a value for a code-listed column:
You can select the column field for the coded column, select the Codelist button to invoke the Edit Code dialog box, toggle to Select, and select a value from the displayed codelist.
You can select the column field for the coded column, clear the field, and key in #n# where n represents the position of the value you want in the codelist. For example, for the category column shown above, you could key in #3# to enter EGGCRATE as the value.
Or you can clear the column field, and key in one of the valid codelist values literally, for example, for the category codelist shown above, you could key in EGGCRATE.
If you key in a value which is not in the codelist, the message Code list entry not found displays, and the field reverts to the previous value.