<< Click to Display Table of Contents >> Navigation:  General Functions > Managing Records > Setting Filters > Expanding the Filter

The current filter may be expanded by simply setting a new filter.  The new filter is set against the current scope of records (which resulted from the current filter).  Each new filter adds to the previous filter as follows:

1. If the existing filter already contains a setting based on the field selected from View items where, then the current setting will be added to the existing setting(s) using the "Or" operator.

Example:

The current filter is set to Number Like 99 and now Number Like 89 is being set.  The new filter will be Number Like 99 Or Number Like 89.

2.  If the existing filter does not contain a setting based on the field selected from View items where, then the current setting will be added to the existing filter using the "And" operator.

Example:

The current filter is set to Number Like 99 and now Serial_no Like US is being set.  The new filter will be Number Like 89 And Serial_no Like US.

Compound filters can be constructed by selecting several settings for the same View items where choice, and several other settings for a different View items where choice.  All the settings for the same View items where choice will be grouped together by "Or", and the various groups will be connected by "And".