Relationships problem

[Shawny]

I have 2 tbls with a 'one-many'. Let's say parents to children. Each person in either one of these tbls can attend a function. I need to keep track of all attendance. The way it is now, I have a separate tbl for each group's attendance. A 'one-many' attendance for parents, and a 'one-many' for the kids. This does the job, but I can't report attendance for everybody on the same report.
So now I have 2 different reports. I need to report the children attendance under the parents name and attendance on a single report. I tried to make just one attendance tbl. The relationships were 'one-many' from parents, and 'one-many' from child. That created join problem for the query.
Any ideas?

 

[BLeslie88]

well....

You could add one field to a table and call it fldAgeType 'or whatever' and make it a select from list. add kids, adults, and any other category you may want to add... this way you could keep both in one table....

Or if you want to keep it all on one record in your attendance record...
Make 2 fields...
ParentsAttendance Yes / no
KidsAttendance Yes / no

You could do various types or reporting on this after with the or / and clauses in SQL...

Hope this helps,