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 !

 

 

Here is a quick example. Hope this helps.

Observation.fmp12