Hey,
I'm sure there should be a way to do this, but I am struggling to find a solution.
We have a parent module called Sites, and a child module called Plots. We are looking for a solution that would achieve the following:
When all Plots belonging to a single Site are updated to Status: Sold, Site status also updates to Sold.
Status is a drop down on both parent and child module.
If there were just 1 plot per site, that would be easy, but as there are multiple, I can't work out how to check all child records meet the criteria before the update triggers.
Thanks