suggest you start with the following tables, as
tblVolunteers ("parent" table)
VolunteerID (primary key)
FirstName
LastName
(any other data that describes a volunteer)
tblProjects ("parent" table)
ProjectID (primary key)
ProjectName
ProjectDescription
(any other data that describes a project)
tblVolunteerProjects ("child or linking" table)
VolunteerID (foreign key from tblVolunteers)
ProjectID (foreign key from tblProjects)
YearVolunteered
(note that i did NOT use Year by itself as a fieldname. Year is a Reserved
Word in Access, and as such, it should never be used as a name for anything
that you build in a database.)
you'll notice i didn't specify a primary key in tblVolunteerProjects. if
the same volunteer can "volunteer to work" on the same project only once in
the same year, then you can use all three of those fields to create a
combination primary key. or you can add a VolunteerProjectID field to the
table as your primary key field.
hth
NathanGrossman said:
Hello,
I would like to know of a method for tracking individual volunteers and
their related projects. Many people volunteer for more than one project,
often in the same year. We want to track for which projects they have
volunteered, and the year they did so. I am using Access 2002 on Windows
XP.
