Volunteer Database

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.

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?

"achapman" wrote:

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.

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






"achapman" wrote in message
...
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.