Search Multiple Critieria fields

Search Multiple Critieria fields

Hi,

I have created 2 fields in the search criteria section. :Category 1 and Category 2. Both of these fields are pick lists. In some of the contact records I have the word sponsor as a pick list option. When I search category 1 for Sponsor it pulls up several records. When I search Category 2 it pulls up another set of records.

The word Sponsor is used in Category 1 for some records and Category 2 for others.

When I try to search using contains “sponsor” in both fields the result is no records found.

I would like to be able to pull up all “sponsors” list in either field?

Does anyone know if this can be accomplished? IS there some type of advanced search?


Respectfully


Austin