Search in the Lookup

The lookup window provides a Search field and a Find button to narrow your search for desired records. This feature is a convenient way to reduce the number of records displayed and helps you to focus on pertinent records.

To search in the lookup

In the lookup window, in the Search field, select the field you want to search. To search in all fields displayed in the lookup view, select Full Text.

For more information, see Lookup Feature - Fields.
In the Operand field, select an operand. For information about available operands, see Filter the Lookup Criteria.

Note The Operand field is available only if an option other than <default> or Full Text is selected in the Search field.
In the Value field, type a search value for the lookup.

Note The Value field is not available if <default> is selected in the Search field, if Range is selected in the Operand field, or if the column you are searching is a Yes/No type column.
Click Find to execute the search. The lookup list box displays the search results.
Select an item from the list box, and press Enter or click Select.

The selected record is copied to the field.