Help...

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

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