Creating table and queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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