How to Use the Picklist Builder - Overview

You use the Picklist Builder to define Picklist Help for a field that uses Referential Validation. You access the Picklist Builder for a field by clicking the Picklist Builder button on the field’s Referential validation Integrity page in the Data Builder.

Picklist Help Grid Options

When you use the Picklist Builder to create a Picklist Help grid, you have the following options:

·       Picklist ID: If you will be creating more than one picklist definition for a field, you use the Picklist ID to identify each definition.

·       Picklist Cursor: Use the Picklist Cursor combo box to select that table, view or CursorAdapter to use for Picklist Help.

·       Picklist Grid Fields: Select the fields from the Picklist Cursor that you want to include as columns on the Picklist grid. Normally, you will include the field in the Picklist table that contains the valid entries for the field for which you are setting up Picklist Help.

Combobox Tip: If you will be placing the field on a form in a VPME combobox control, the combobox list will display each field you select in a separate column. The first field in the combobox list is the field displayed when the list is not expanded and is the only field with incremental search. None of the fields in the list are sortable. If you will be displaying a descriptive field from the Picklist Cursor on the form instead of the field itself, the description field should be the first field listed in the Picklist Builder so that it is displayed when the list is not expanded and so that the incremental search will be enabled on that field.

·       Calculated Fields: Create calculated fields by clicking the Calc button.

·       Selected Field Properties:

·       Grid Column Caption: By default the Caption is the Picklist table field’s Description (Short) property entry in the Data Builder.

·       Order Tag: If the Picklist Cursor is a table, select a tag to be used to sort the field’s column. Selecting a tag for a column makes the column a sortable column.

·       Search: Turn on incremental search for a field column. You can select whether the incremental search should be case sensitive.

·       Records Displayed: Select the number of records to display when the Picklist grid first appears. By default the Picklist grid displays 5 records. The Picklist form is resizable and users can change the number of records displayed after the List form appears.

·       Maximum Form Width: Select the maximum Picklist form width in pixels. By default the Picklist form automatically sizes itself to fit the fields you select for the Picklist grid. If you select more fields than can be displayed on the desktop screen, the Picklist form automatically leaves a 20 pixel left and right margin. At low resolutions the Picklist form may become unacceptably wide if the Picklist grid contains more columns than can be displayed on the screen. In this case, you may want to set a maximum Picklist form width that matches its associated form’s width in pixels.

You can use the Picklist Builder more than once. The Picklist Builder remembers the settings that you chose. Each time you use the Picklist Builder, the Picklist grid will be rebuilt with your latest Picklist Builder selections.

Tip – Multiple Picklist Definitions: When you want to create more than one picklist definition, click the New button and start an additional definition by entering a Picklist ID.

Tip – Default Picklist ID: The picklist definition with the “<default>” Picklist ID will be used when you put a control on a form and leave the control’s cPickListID property empty.


How to Use the Picklist Builder - Details