Showing multiple results in layout
I have tables joined that I require help please!
Table 1 Child Data - holds data about each child
Table 2 - Observations made - lots of observations made about each child and they are set into group, and age ranges
Table 3 Tracker - should show the results of the observations displayed via agree range, group and how they are performing against set criteria
e.g if the child has completed less that 50% of the criteria for that group show date observed in one place, over 50% show in another, over 75% show in a third
There are 7 groups and 6 age ranges and I am in a confused state!
What does one record in Tracker represent?
What is a "group"? A group of children (all those age 5 or ...)? A group of observations? Or?
What is an "agree range"?