Step 1 Define New Fields

Step 1. Define New Fields

VFW102 – Field Visualizations in a Grid

In this step you will define three new fields for employees: On Leave, Status and Memo Notes.

You will also create a picklist for salary.

1.  Create the following fields:

Name Description Type Length Default Value iiiOnLeave Employee On Leave Flag Alpha 1 N iiiStatus Employee Memo Status Alpha 3 NML iiiMemo Employee Notes String 512

2.  Create field iiiEMPNO by copying field EMPNO. Copy rules, visualizations and help text. No changes to iiiEMPNO are required at this stage.

3.  Create field iiiSALARY by copying field SALARY. Copy rules, visualizations and help text.

4.  Create field iiiTAXPAID by copying field SALARY. Do not copy rules, visualizations or help text.

5.  Open field iiiTAXPAID in the editor and create add a Static Picklist and define the following values:

Caption Value Small 1 Medium 1000 Large 5000 Very Large 10000

6.  Save your changes.

 

7.  Define a Static Picklist for field Employee Memo Status, which includes image components:

Image Caption Value Default xImageFavorites16 Normal NML Yes xImagePause16 Urgent URG   xImageNew16 Late LTE   xImageOpen Very Late VLT

     Note that the VisualPicklist component will default to a DropDownList. Only the Picklist component will be used by the Grid component. To use this visualization on a form or panel, you would set the VisualChecklist to Image or Image and Text.