The application will search the employee table (xEmployee) using SELECT_SQL, using a search on Date of Birth comparing the month value only. In this step you will create a month field and define a static picklist visualization for it. This will be visualized as a combo box which returns a numeric month number.
1. Create a new field, iiiMONTH based on the following:
2. With the new field open in the editor, select the Visualization tab.
Use the toolbar button to insert a Static Picklist
3. In the Field Parts panel, select the picklist item and create entries for each month.
The default appearance of a picklist is a DropDownList. Do not change this setting:
4. Set the properties of the VisualizationPicklist element in the Details tab:
a. Change its MarginLeft to 0, to hide the label.
b. Change its DefaultVisual property to True.
c. Resize the DropDownList visualization as shown:
5. Save the field definition and close it.