One of my tables is a JOB table and I want the ability to for the office staff to manual lock a record. This usually happens after a job has been scheduled and the customer has been called. This works great except for one small problem - I can't unlock it! I've painted myself into a corner.
I have a privilege set named "Admin" and the Records are "Customized privileges..."
JOB table, in the Edit column is "limited...", defined as appointmentStatus="Unlocked"
JOB::appointmentStatus field is a pull-down field and I've attached a script trigger OnObjectModify that changes "Locked" to "Unlocked" and runs with Full Access privileges (the problem doesn't occur with Full Access). However, the script never runs; I get the message that my privileges do not allow this action.
Any ideas how I can change the JOB::appointmentStatus within this privilege set?