>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]
