Why don't I get any results when using the "Assistant Coach" field in the Find Teams query?

The Assistant Coach field only looks at the primary assistant coach assigned to the team detail record on the general tab, so if no one is designated as the Primary Assistant Coach, criteria on this field will return no results. To look at all people who are designated as assistant coaches, use the Assistant Coaches field instead and set the criteria to “contains" to filter your results.