Hi,
I have a field called "Status" and if this is set to a certain value (e.g Awaiting Approval", I want to prevent users from locking a row out and making changes.
The reason for this is that managers routinely run update queries which set various values if they approve the input and if users are in said records, these updates of course fail (due to record locking behavior).
Kind Regards
I have a field called "Status" and if this is set to a certain value (e.g Awaiting Approval", I want to prevent users from locking a row out and making changes.
The reason for this is that managers routinely run update queries which set various values if they approve the input and if users are in said records, these updates of course fail (due to record locking behavior).
Kind Regards