You can do your find two ways:
You click Find and then check both "apples" and "oranges" and hit "Perform Find".
That way you are looking for records where both apples and Oranges are selected. (An AND find)
You can also do an OR find.
You hit Find, you check "Apples" then you click "New Request" on the top and it's like you got a new record, but it's still in find mode, so you didn't create a new record. But a new find request.
Now you check "Oranges" and hit perform find.
This find should return all records that have either "apples" OR "Oranges" selected.
thank you, i guessed as much
i was hoping that there was some way of making that particular field/data value always work as an OR in searcges, if that makes sense.
but no worries, my colleagues will just have to do it as you say. thanks again.
Scripts can be used to make finds more user friendly. This forum contains a number of threads on scripted finds.