4.4.9.5 Defining List of Values

While creating a Form, if you choose the Select List field parameter option in the In Edit/Add column in the DEFQ Field Properties Window, you need to define the list of values in the Select List Window. However, you do not need to define the values for foreign key fields and primary key fields.

In the Select List Window, select the required Field Type from the following options:

• Comma Separated Values : Supports only the user-specified values while creating a Form.
• Dynamic List of Values : Supports field name from a table and stores it in the database. The same can be used during Data Entry.

If Comma Separated Values is selected:

1. Enter the List of Values to be displayed.
2. Specify Alternate Display Values to be displayed.
3. Click OK and save the specified list of values. If Dynamic List of Values is selected:
4. Select Table Value, List Value, and Display Value field.
5. Select the Field, Operator, and Functions from the list.
6. Define a filter condition for the selected values.
7. Click OK and save the specified list of values.