SaviNewman1
2 years agoQrew Trainee
Complex Formula maybe?
I understand what I want to do, and some of what I need to do - I just can't seem to implement it.
We have many tables.
We have 2 tables in particular that already have a relationship called Water Systems and Samples.
Water Samples are input and assigned to water systems.
We get a notification whenever a sample fails - which is great.
However, when a sample fails, we're required to take another sample some weeks/months later.
We would like to be notified when a sample comes back passing again once a sample has already failed.
So,
take sample>failed>take another sample>passed after recognized failure>send notification.
Ideas?
------------------------------
Savi Newman
------------------------------