Creating table and queries

[Guest]

I'm very new to Access (trying to teach myself) and have several Committees
within an organization with the same person(s) being a member of more than
one committee and with a different title (function) in each committee. I've
created a table for each committee but not sure if this is the best way to
keep track of these committees, i.e. when the committee members change or
need updated. I feel like I just created some redundant work, why not just
set each Committee's Member List in a separate table, say using Excel?? I
really don't know what I'm doing so could use any suggestions that anyone may
have.

 

[John Vinson]

I'm very new to Access (trying to teach myself) and have several Committees
within an organization with the same person(s) being a member of more than
one committee and with a different title (function) in each committee. I've
created a table for each committee but not sure if this is the best way to
keep track of these committees, i.e. when the committee members change or
need updated. I feel like I just created some redundant work, why not just
set each Committee's Member List in a separate table, say using Excel?? I
really don't know what I'm doing so could use any suggestions that anyone may
have.

One table per committee is NOT correct.

You have a classic "Many to Many" relationship. To model this you need
*three* tables:

People
PersonID ' primary key, either autonumber or a unique employee no.
LastName
FirstName
<other biographical data>

Committees
CommitteeID ' Primary Key
CommitteeName
<other info about the committee as an entity>

Membership
CommitteeID ' link to Committees
PersonID ' link to People
Title ' perhaps a link to a small table of roles
<any other info about this person's membership on this committee,
e.g. date started, date ended>

You would use a Form based on either the People table or the
Committees table, with a Subform based on membership.

John W. Vinson[MVP]