Text Fields Connected to a Lookup

Text fields that are connected to a lookup for validation list the acceptable values for the field in the field, along with an option to select multiple values and an option to only select records in which a value exists.

Define a Report Criteria Expression for a text field validated by a lookup table:

1. Locate the field for which you want to specify report criteria.

2. Choose between two options:

   • Selecting is returns all records where the field matches the value.

     For example, Status is Issued would return all records in which the value for status was Issued.

   • Selecting is not will only return records in which the field does not possess the specified value.

     For example, Status is not Issued would return all records in which the value for status is something other than Issued.

3. Choose between three options:

   • To select a single value for the field, select the value you want from the field.

   • Select multiple values for the field:

     1. Select the Select Multiple… from the field.

        A window opens, prompting you to select the values you want to include.

     2. Select the value you want in the Available field.

        Press and hold the CTRL button on your keyboard to select multiple values.

     3. Click the move arrow .

        The values move to the Selected field.

     4. Repeat this process to select any additional values.

        If you have selected a value in error, select the value in the Selected field and click the remove arrow .

     5. Click the Apply button.

        The window closes and the field on which criteria was specified reads <Multiple Values>.

   • To filter results to only records where the field is not blank or empty, select Value Exists from the field.

     The window closes and the field on which criteria was specified reads [Values Exist].

4. Specify criteria for additional fields validated by a lookup table using the above instructions.