Issue with results when performing finds involving a check box list
I'm having a problem with a very simple database i've put together but can't seem to figure it out.
The database is a contact list of people we work with. Most the fields are either standard text based fields (first name, surname, etc) or dropdown lists (one for geographic regions for example).
There are two check box fields though which are causing me a headache. One of these is a list of products they like to receive from us and has around 10 options (let's say apples, oranges, pears, strawberries etc).
The problem is when I want to perform a find for people who, for example, like oranges and/or apples. Currently the find only returns those who have both apples and oranges ticked.
I'm sure i'm just being stupid but can't find a way to make it work.
Thanks for any help!