I decided to make of my fields a checkbox with several options (different materials to be used in cleaning). Everytime I make a search where I only select ONE option in my check box (eg.soap) records where I did not mark soap on the fiel with the check box appear as well (because they contain the word soap somewhere else). I want only the records where I marked soap in that checkbox (even if it is not the only ingredient). It can not be a search using the omit option because sometimes I have more than one option marked in this check box.
Can someone please help me?