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!