Suppose I have records modeling users. Each user can be a member of
any number of groups (like how a unix user can be a member of any
number of groups). Whats the best way to implement this?

I think I would prefer if it was possible to have an enum field in the
user table which could store multiple values per record (one per
group) but the only practical way I can think to do it is to create
tables for each group and store the users primary key in the tables
corresponding to their group membership.

Following me? Any better ideas?

EMAIL REMOVED wrote:
> Suppose I have records modeling users. Each user can be a member of
> any number of groups (like how a unix user can be a member of any
> number of groups). Whats the best way to implement this?
>
> I think I would prefer if it was possible to have an enum field in the
> user table which could store multiple values per record (one per
> group) but the only practical way I can think to do it is to create
> tables for each group and store the users primary key in the tables
> corresponding to their group membership.
>
> Following me? Any better ideas?
>

Google for "database normalization" - it should help.

You need a table which contains two columns - a group id and a user id.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
EMAIL REMOVED
==================