If "(IsEmpty(Lock) or Get(ActiveFieldName) = "Lock" ; 1 ; 0 )"
You don't actually have the quotes I've shown in read do you? They shouldn't be there, but I'd expect you to get an error message if that's how you entered your actual lock expression.
No I do not have Lock in quotes, i copied that from a reference file I keep.
The actual from the privilege set is:If (IsEmpty(Lock) or Get(ActiveFieldName) = "Lock" ; 1 ; 0 )
In addition to not being able to cut and paste, the Filemaker menu bar containing "New Record, Delete Record etc" is grayed out and unaccessable?
Go to manage | security and edit the privilege set. There's a drop down in the lower right corner that controls what menu options are available. Select a less restrictive option that includes more menu options in your menus and this will likely work.
PS. Your lock expression can be simplified to be:
IsEmpty(Lock) or Get(ActiveFieldName) = "Lock"
Contrary to what you might think from the example in FileMaker help, the if function is not needed in your expression.
Thank you once again Phil, the drop down solved my problem and the new lock expression is much cleaner.