I have created a database that contains several tables including the following .
Children
Observation Records
I need to be able to track the observation records and compare them to a criteria that counts the number of observations and when they reach a threshold "stamp" the record.
Example:
The Child needs to reach 10 observations overall.
When 1st observed - stamp "Just In' and the date it was achieved
When 7 observation records achieved - Stamp "Comfortably in' and the date it was achieved
When 7+ achieved - stamp "Securely in" and the date it was achieved
This then needs to be tracked so that progression can be tracked over time.
I have no idea how to even start with the solution!! Any idea`s on where to start would help
Thanks for reading !
