Best way to handle multiple associations

I'm looking for advice on how to handle this.  I have a members table.  And I have a Committees table.  A member may belong to one or more committees.

So I assume in the members table I need a committee ID field that stores the committee ID number that the member belongs to.  But what if they belong to more than one committee?  How can I handle the storage of multiple committee IDs?

--Steve
SteveL13Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
you have to create a third table

table name - MembersCommitte

fields    ID, memberId, CommitteId


see this demo

http://office.microsoft.com/en-us/access-help/demo-set-the-relationship-between-two-tables-HA010254901.aspx?pid=CH100739911033
0
All Courses

From novice to tech pro — start learning today.