Help...

[Guest]

I am new to access and am losing my mind. I am trying to set up a simple
database that will keep track of PTO members and the committees they would
like to join. I think I have the database set up correctly...in tables with
following fields:

Committee table: committee ID, committee name, committee description
Committee member table: committee member id, committee ID, volunteer ID
Volunteer ID table: volunteer id, first name, last name, address, etc...
Class table: class ID, teacher last name, grade
students table: student ID, first name, last name, class ID, volunteer ID

The idea is to create a database of parent school volunteers based on their
committee involvement and childrens' names and classes in the school

I am so stuck on something so simple...How do I create a form that will
allow me to input data into my tables by linking everything to the volunteer
table. I can figure out how to link volunteers to their students and the
classrooms, but I cannot seem to figure out how, in one form or with
subforms, to link parents to their committee choices.

Help, Help, Help....

Thanks in advance!

 

[Ed Robichaud]

Congratulations, the table structure looks good, however, if student can be
in more than 1 class, I would recommend changing the Student and Class
tables so that studentID is a foreign key in tblClass. Be sure to use
"Tools-Relationship" menu to set relationships between tables.

Try creating a form (single record) whose record source is the tblVolunteer;
add a subform (datasheet) whose record source is the tblCommittee - the
master-child link will be the volunteered fields/controls in each. This
layout will then give all the committee records for each volunteer. You
could reverse the layout to display/input the volunteers for each committee.
You can also have more subforms on the main volunteer record to
display/input the tblStudent records.
-Ed