Filter Editor Dialog

The Filter Editor dialog, accessible from the Select Records dialog or the print-time Record Picker data entry control, allows you to create a custom filter using a complex expression with one or more conditional statements that can be based on one or more of the database fields.

To open the Filter Editor dialog, select

Filter Editor from the context menu anywhere on the Select Records dialog or record picker control.

Click And to select a condition for the filter.
Click to create a new filter condition.
Click the [column] item to select a field to add to your filter. By default, the column from which you opened the dialog is selected.
Click [Begins with] to select the operator that you want to use. "Begins with" is the default operator for new conditions.
Click <enter a value> to enter the value that you want the condition to evaluate.
If desired, click to add another filter condition. You can always remove a filter condition by clicking .
When you've finished adding filter conditions, click Apply to apply your filter and see the results. Alternatively, click OK to apply your changes and close the dialog.