I have this syntax in a valid_if ref:
SELECT(REQUESTS[EMP ID],[D1S2]=TRUE)-SELECT(SCHEDULE[D1S1],[SITE ID]=[SITE ID])
The idea is this: The user selects a value in column D1S1, then what should happen is: If the list of values in my request table has the value selected in D1S1 it removes the value from the list.
This works great only if i save first and then go back and edit the row again.
I need this to run without saving the record first.
I have the same syntax in a virtual column and it doesn’t re-evaluate as well.
Any idea would be appreciated.