I'm trying to build
something for a client that will allow people to match up with each other based
on a variety of different criteria.
Each person fills
out the same form but they are allowed to make
multiple selections for each criteria. For example if one person chose
ON, NS, QU as their Provinces and another person chose ON, MN, BC. That would
register as a match. Here is the tricky bit. the Client wants to allow the user
to be able to choose multiple Countries and about 8 other variables are
also going to have more than 1 possible answer. I'm not sure how to handle this.
Another Question.
Right now all of the
multiple variables are stored in the same field as comma delimitated lists. Is
there a way I can compare a list to a list? If I can do that I'll be set.
