Make a back up copy of your file just in case you make a mistake and have trouble accessing your database.
Use this script for your lock button:
Set Field [YourTable::LockField ; not YourTable::LockField ]
Click the "run with full access privileges" check box if you want limited access users to be able to unlock the record after it is locked.
Where LockField is a number field. This script will toggle the value in this field between 1 (locked) and 0 (unlocked).
In Manage | Security, bring up an account with a privilege set where you want this "lock" method to work.
Specify custom privileges for Reords, select your table in the list that appears and select "limited..." in the edit drop down.
Enter this calculation as the lock expression:
make the same choices in the Delete drop down if you want to prohibit deleting locked records.
Click OK until you have left manage | security.
Close and reopen the file, using an account name and password associated with this privilege set. And now you should be able to lock and unlock records in this table.
Thank you. You are such a big help! What is the best way to be able to tell if the fields are locked or unlocked? Is there any way to specify some sort of a "locked" indicator or something?