You must group multiple AND/OR search sequences to ensure that Sierra returns the results that you want. Ungrouped AND/OR searches are prone to ambiguous interpretation. Although the search might run, the results might not reflect what you were searching for.

For example, consider the interpretation of "black and white or gray" versus either "black and (white or gray)" or "(black and white) or gray". With grouping, even a more complex search such as "((black or red) and white) or gray" can be interpreted clearly. With grouping, you can be confident that you are getting the records you want.

Specify your search criteria for the first term.

Choose Append Line to add a search term to the end of the search term list. Choose Insert Line to add a search term before the selected term. The system searches for terms in the order that they appear in the table.

In the Operator cell of the new search term, choose "and" or "or." The cell's Operator defaults to "and."