The solution will depend on how you have this data stored.
Presumably you have already set up tables for:
- students,
- parents,
- the connection between students and parents,
- issues (such as allegies),
- the connection between students and issues,
- events (dates when Sunday School events are held),
- attendance (link between students and events),
as well as other tables such as Staff.
When the parent drops the child off for an event, you are therefore entering
the attendance record. This record includes the StudentID and the ParentID
(related to their respective tables). You can therefore use these values to
limit the label reports to just the student and parent in this record.
Steps:
1. Create a query containing Student and StudentIssue tables.
To ensure this works even if a student has no allegies, double-click the
line joining the 2 tables. Access opens a dialog offering 3 options. Choose,
"All records from Student, and any matches from StudentIssue."
2. Create a label report based on this query.
Don't worry about the fact that this currently prints all students.
3. Create another label report linked to the Parent table.
Don't worry that it prints all parents.
4. On the form where you enter the Attendance record, add a command button
that performs these actions:
a) Saves the entry.
b) Prints the first label report, filtered to the student.
c) Prints the second label report, filtered to the parent.
For an example of how to filter the reports, see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
> I'm trying to create a data base for our Sunday School, where we register
> children as they arrive. As I click on the present tag (In the Student
[quoted text clipped - 8 lines]
> tables) and then one for the parent with different columns. I'm using
> Microsoft Access 2002.