Security, locking a record
In Filemaker 11.0v3 I created a field named "Lock" that is a check box.
I created a custom privilege set that included a limited edit statement of If "(IsEmpty(Lock) or Get(ActiveFieldName) = "Lock" ; 1 ; 0 )"
When the box is checked the users cannot edit anything in the affected record, when unchecked they have their typical access.
The issue that has arisen is that even though the box is unchecked, my users are unable to copy and paste into any field.
Is this a negative side effect or...What the heck did I do wrong?!