One suggestion I just got looks a lot better than what I have up there.
Please let me know what you think:
Try something like this:
TABLE: User
DESCRIPTION: Individual user.
PRIMARY KEY: [UserID]
FIELDS:
...UserID
...UserName
TABLE: Counties
DESCRIPTION: List of known counties.
PRIMARY KEY: [CountyID]
FIELDS:
...CountyID
...
oneraven
Last Activity: Apr 26 '09, 10:40 PM
Joined: Apr 15 '09
Location:
-
Would I be better off with a MetaTerms table with one entry for each term each user enters?
AutoNumPK|UserI D|TermLeave a comment:
-
Query Multiple User-Defined Meta-Terms
I want to have people search for people by professional function, and limit that search to the areas in which the professional is willing to travel to/work in.
The areas are broken down into counties.
The professional can choose just one county - or up to 20 (possibly more - I haven't yet decided).
The professionals will be setting their own search meta terms. For example, a roofer might use [roofing, siding, windows,...
No activity results to display
Leave a comment: