The answer to the 2nd question is to build a table incorportating a many to may relationship between the person and location.
That would go a long way to solving your first problem as well. As far as the multiple countries and all that go, depending on your application, you may want to store all locations (province, state, country) in the same table and give them different IDs. Forget the post office type location codes. Do something like this. Location_id Location 1 Ontario 2 New York 3 England Good luck. **************** 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. - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
