What tables do I need?

[jon@thebear]

I have an organisation with many members and committees. I want to record
what members belong to which committees, in Access. Each member can belong to
several committees. What tables do I need to set up?

 

[Larry Daugherty]

Since you will have a many-to-many relationship you will need three
tables:

tblPerson: every person in your application

tblCommittee: every committee

tblPersonCommittee: one entry for every instance of
a person in a committee

HTH

 

[scubadiver]

Just to clarify Larry's message:

tblPerson
PersonID (PK)
Name

tbleCommittee
CommitteeID (PK)
Name

tblePersonCommittee
PersonID (FK)
CommitteeID (FK)


1) Put Committee in the main form

2) Put "PersonCommittee" in the subform BUT use the person table as the
source for the PersonID FK.

 

[Steve]

Just a note about ths suggestion ---
The tables are correct but do not use "Name" as a field name. Name is an
Access reserved word and sooner or later you will encounter a problem when
you use it as a field name.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)