Hi,
I am developing a Services Directory where one individual (a service provider) may promote multiple services in one or more geographical regions.
If the individual (service provider) only selects ONE region, the filter works fine. ie: user1 operates in region1, then they appear under the list for region1
However, as soon as a user selects MORE THAN ONE region, ie: user1 operates in region1 and region2,
they no longer appear in lists for either region1 or region2.
I am currently using a list filter where 'cb_region' ='region1'.
I have tried to select 'cb_region' LIKE'%region1%' and this DOES work, but the result displays a list that includes other users where the region name is similar, ie: 'cb_region' LIKE'%city west%' also lists anyone who is in other regions such as city south west, city north west, etc.
Any assistance would be greatly appreciated!
This is my first project with CB, and have been faced with a steep but ENJOYABLE learning curve
Post edited by: JoomIM, at: 2010/07/04 05:31