I have a table called 'Equipment List' and table called 'Projects'.
I have a single select field in Equipment List called 'Availability' with 2 options, IN and OUT
I have a single select field in Projects called 'Status' with 2 options, COMPLETED and RUNNING
In the Projects table, I have a linked field to Equipment List, allowing to link to multiple records.
The functionality I would like is:
IF Status field in Projects is set to RUNNING, then all the corresponding items in Equipment List field, change their Availability field in the Equipment List table to OUT, otherwise set to IN.
What is the easiest way to do such a thing?