If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Volunteer Database
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. |
Thread Tools | |
Display Modes | |
|
|