Database structure problem
I am building a system that allows classroom teachers to record observations of children. An observation is of one or more children doing an activity that represents one or more of the 18 aspects of the curriculum. When the observation is complete a script populates an intermediate table with records which link one child with one aspect, so that if the observation is of three children doing an activity that involves both maths and writing we will have six records.
I now want a layout that shows for each child the 18 aspects of the curriculum and how many observations have been made of that child in each aspect. It's easy to show this for those aspects that have been covered, using a summary field and a subsummary part on the layout. But I want a tabulation of all 18 with a zero next to those that have not yet been observed (this is the most important piece of information as far as the teacher is concerned).
Of course, a teacher can surmise the zero from the absence of an aspect from the list, but this would make side-by-side comparisons of reports difficult and in any case it is something that a database ought to be able to do, surely.
Thanks in advance.