Question:

How can I create a search with multiple comparisons - ANDs and ORs?

Answer:

Use a Sub-Group in an Advanced Find.

Sub-Groups allow you to mix and match comparisons (ANDs and ORs) within a single Advanced Find. When you want to change from AND to OR or vice versa, you need a Sub-Group. By that same token, you only need a Sub-Group when you want to change from AND to OR or vice versa! CDM+ enforces this rule, and while it may seem overly controlling at first, we suggest you give the interface a chance to help you structure and understand your searches.

To provide an example of how Sub-Groups work, let’s use the example of families whose last name begins with C, and who live in Big City. What if we want to amend the search to find families whose last name begins with C and who live in Big City or Versailles? Note that this search, when verbally described, contains both an AND and an OR. This means that you need to involve a Sub-Group.

Steps and screenshots for using Sub-Groups in Advanced Find.