simple pto database

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

Guest

I am trying to set up a simple pto datbase tracking which parent signed up
for which committee then sorting the parents with all the pertinent info by
committee. example - all those who signed up for fundrasing. not sure if i
know even how to begin!

thanks!
 
I am trying to set up a simple pto datbase tracking which parent signed up
for which committee then sorting the parents with all the pertinent info by
committee. example - all those who signed up for fundrasing. not sure if i
know even how to begin!

thanks!
Click to expand...

You'll need at least three tables:

People
PersonID <autonumber primary key>
LastName
FirstName
Phone
<other contact/bio information as needed>

Committees
CommitteeName <Text primary key>
<information about the committee as a whole>

Assignments
PersonID <who's on this committee>
CommitteeName <what committee are they on>
Role <e.g. Chair>

You may also want a table of Meetings, with fields for CommitteeName,
MeetingDate (use the date and time in one field), etc.

John W. Vinson[MVP]
 
Back
Top