I have created a new field for CB, its a multi select list, i.e. we can select multiple values from:
member
committee
director
actor
stage
magician
When I create a CB List where the filter is LIKE 'member' the list returns those people who have member ONLY saved, if they have member AND director, then they don't get included in the search result.
Please advise.