So anytime I have a list of anything within a list when I don't want to do "a|b|c", I go to a lookup table and abstract (if that's the right term) both sets. What I was missing mentally is having multiple entries for a person in the user/groups section.
I guess this means that I can't just use CF Query="" to root through a list and have to do my own looping to up the loop numbers through vars with multiple people entries.
>No, I'm suggesting the following:
>
>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]
