Locking a record

Title

Locking a record

Post

I am using FM Pro 10

I have a database that is shared by various users who input data onto specific layouts. Once a record is complete, I want to be able to lock the record so that it can no longer be edited by those users. As the admin, I want to have the ability to edit the record if necesssary.

I have tried to set up a limited access using:

File:Accounts and Privilages: and editing the privalege set for the user

If I set the Custom Record Privilages to limited

This is where I get stuck. I have a field called Lock and want to use that so that if I as the admin can set the status of that field to lock out the file.