Access Database - Board of Directors w/ Different Committees

V

vnelson

I am trying to put our Board of Directors in an Access database and we have
several different committees that our members serve on. They may serve on
several different Committees.... I'm not sure the best way to enter this.
Should there be 2 tables, one for the members and one for the committees? If
so, how do I link them?
 
K

KARL DEWEY

With a third - junction table. Set one-to-many relationship between the
Members and junction table and also between the committees and junction table.

Use a form/subform for data entry of Member/Committees with Master/Child
links set on the MemID of Member form and Committees subform. Use a combo
box in the subform to select the committee the member belongs to. Have
fields for joined date, and something like departdate with criteria for
departdate Is Null to show in subform.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forms 3
How to set up a many to many relationship 3
Switch() Clause within the same field, different record?: 1
Creating table and queries 1
table design: members/committees 1
Corporate database assistance 3
list within a field 6
Open Matching Record in a Form in Another Database 0

Top