Volunteer Database

[Guest]

I have created a database with the following tables: Students,
Parents-Guardians, Teachers and Volunteer Opportunities. My question is
about the Volunteer Opportunities table. I have set up two fields within
that table: Op ID and Volunteer Opportunities.

I need to create a query for each opportunity so that the volunteer
coordinator wants to pull all parents-guardians that volunteered for that
initial activity can be contacted.

Have I set it up correctly? How can I set up the query to get what I want?
I assume I have to have a query for all 35 opportunities... I've been working
on this database all day and my mind is going blank.

 

[Guest]

Update Note: I have created another table that has the Primary ID, ParentID
and OpID (for the Volunteer Opportunities). Should I use this table for my
query instead?

 

[Steve]

Change the name of your Volunteer Opportumities table to just TblOpportunity
and rename your Volunteer Opportunities field to just Opportunity. Then
create a new table
TblVolunteerOpportunity
VolunteerOpportunityID
OPID
ParentGaurdianID

Record who volunteers for each opportunity in this table.

Create your query to include Parents-Guardians, TblOpportunity and
TblVolunteerOpportunity.


PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)