GROUPS
GroupID GroupName
1 Family Studies
2 Kinnesiology
USERS
UserID UserName
1 John Burns
2 Daniel Kessler
USERGROUPS
UserID GroupID
1 1
2 1
2 2
Which would mean that John Burns is in Family Studies while Daniel
Kessler is in Family Studies and Kinnesiology. I hope that helps.
John Burns
-----Original Message-----
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 21, 2004 2:22 PM
To: CF-Talk
Subject: Re: DB field setup
>Seems like you need a lookup table (in case the possibilities ever
>increase from 3 to X). Then you can either store the IDs in a
>comma-delimited list or do another lookup table where you insert the
>userID and the type they are. Then each user can be in multiple
places.
While I agree that I probably need a lookup table, I don't really
understand your suggestions. Are you suggesting a Family_Studies tables
with a set of names? And would I do an INNER JOIN to grab that
information?
I'm a bit new to DBs.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
