Lock a field?
I know you can lock an entire record, but is there a way to lock one field of one record?
In the file I have, if the field "Status" = "ValueX" I want the user to be able to modify other parts of that record, but not change the value in the status field. Basically make it so that to change from ValueX to ValueY or ValueZ, the record must be duplicated via a script that runs with admin privileges that changes the value. Need to keep the ability if Status = ValueY or ValueZ, the user can change Status at will.