Basically I want to create a script that looks at a set of values from a related table.
If all values = "Assessed" etc
then change status = "Complete"
But if one of the values within the search doesn't = "Assessed" then no status change.
Next time script is ran. All values = assessed mark as complete etc etc
I only want to create something like this to automate status changes from say a button. Rather than having to go to the exact record once the criteria has been met and change the status.
What would be the best way in doing this?