1

Topic: Search multiple fields = how?

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: <dropdown of 20 locations>
Location 2:  <dropdown of same locations>
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. smile

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!

Last edited by slinky (2010-07-12 21:22:21)