Search multiple fields = how?

2010-07-13T01:21:34Z

I've got a unique site - I'll give you a good example. It's a hookup board where people can choose different locations they want to meet people. For free, you can select up to 2 states. For bronze membership, it's up to 4, silver 5 and gold 6.

There is no way that I can see where I can have a checkbox of 20 locations and have users be able to select only up to x number based upon their membership so my idea was creating a locations field and using ti six times. So it will be:

Location 1:
Location 2:
Location 3: ....

Is there a way in VLD (there has to be a query modify) where you can have search show up for Location 1 but include an OR statement so that it would be

If stateselected = location1 or location2 or location3... THEN return YES.

This way in the search, finding the location in any of the six field entries returns a positive result. I think this is useful in many ways but is probably not the norm for most.

PS - Also Tried to get hold of Ramil or someone to do custom programming as well but doesn't look like he's around or just too busy with projects!

vldPersonals Forum - Search multiple fields = how?

Search multiple fields = how?