AnsweredAssumed Answered

Issue with results when performing finds involving a check box list

Question asked by JohnPower on Jul 16, 2012
Latest reply on Jul 16, 2012 by philmodjunk

Title

Issue with results when performing finds involving a check box list

Post

Afternoon,

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!

 

Outcomes