I need a template that will list 200 volunteers for 20 different jobs.
This would be very simple to build as an Access database: three
tables:
Volunteers
VolunteerID
LastName
FirstName
<contact info, address, phone, email, ...>
Jobs
JobID
JobDescription
<any other info about the job, e.g. dates>
Assignments
JobID
VolunteerID
Role <if needed or appropriate>
You'll need two forms - one for Jobs, one for Volunteers with a
subform based on Assignments; and at least one Report, based on a
query joining all three tables.
This will allow you to assign tens of thousands of volunteers to tens
of thousands of jobs, if needed.
John W. Vinson[MVP]
