How code tables are implemented

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 for specifying 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 information on how to create an edit style, see “Working with edit styles in the Database painter”.

Allowing NULL values An internal PocketBuilder 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:

Select the Use Code Table check box.
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, select the Validate check box.

For more information, see “Validating user input”.

To define a code table as a property of the DropDownListBox edit style:

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, clear the Allow Editing check box.

For more information, see “Validating user input”.

To define a code table as a property of the RadioButtons edit style:

Enter the display and data values for the code table.
If you want the radio buttons to display on a single line, enter the number of rows in the Columns Across box that you entered in the code table.

To define a code table as a property of the DropDownDataWindow edit style:

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 to values in the code table, clear the Allow Editing check box.

To define a code table as a property of the EditMask edit style:

Select the Spin Control check box.
Select the Code Table check box.
Enter the display and data values for the code table.