You can define a code table as a property of the following column edit styles:
Edit
DropDownListBox
RadioButtons
DropDownDataWindow
EditMask, using spin control
The steps to specify the code table property for each edit style are similar: you begin by defining a new edit style in the Database painter. Once you select an edit style, use the specific procedure that follows to define the code table property.
For how to create an edit style, see “About edit styles”.
Allowing null values
An internal DataWindow Designer code, NULL!, indicates null values
are allowed. To use this code, specify NULL! as the data value,
then specify a display format for nulls for the column.
To define a code table as a property of the Edit
edit style:
Set the CodeTable property to true.
Click the browse button next to the Values property and enter the display and data values for the code table.
If you want to restrict input in the column to values in the code table, set the ValidateCode property to true.
For more information, see “Validating user input”.
To define a code table as a property of the DropDownListBox
edit style:
Click the browse button next to the Values property and enter the display and data values for the code table.
If you want to restrict input in the column to values in the code table, set the AllowEdit property to false.
For more information, see “Validating user input”.
To define a code table as a property of the RadioButtons
edit style:
Click the browse button next to the Values property and enter the display and data values for the code table.
To define a code table as a property of the DropDownDataWindow
edit style:
Click the browse button next to the DDDW_Name property and select the DataWindow object that contains the data for the column from the list.
In the Display Column property value, select the column containing the values that will display in the DataWindow object (in the example, dept_name).
In the Data Column property value, select the column containing the values that will be stored in the database (in the example, dept_id).
Specify the column that provides the display values in the Display Column box.
Specify the column that provides the data values in the Data Column box.
If you want to restrict input in the column to values in the code table, set the AllowEdit property to false.
To define a code table as a property of the EditMask
edit style:
Set the SpinControl property to true.
Set the CodeTable property to true.
Click the browse button next to the Values property and enter the display and data values for the code table.
