Grouping items

[shzawn]

Hello all,

I am trying to accomplish something that seems relatively simple yet am struggling to figure it out. I basically want a table of Groups and a table of Members, and I want to be able to select which Members are in a particular group. Therefore, a Member could be in more than one Group, but not neccessarily. So for each Group entry, there would have to be a list of Members that belong to that particular group. Is there an easy way to accomplish this in Access 97? Thanks in advance for any help, I really appreciate it!

Regards,
Shawn

 

[shay]

Hi

I'd suggest 3 tables:

tblGroups: GroupID, GroupName

tblMembers: MemberID, MemberName, etc

tblMembership: GroupID, MemberID

A simple query will give you a list of members for a particular group.

hth

shay

 

[shzawn]

ty

ty shay, that's an excellent suggestion.

looks like someone has a case of the mondays (me).