SeedCode Support Forum

I have used privileges to allow some users to lock records to prevent accidental changes. Now I need to somehow lock the same records, but this instance only other users can unlock.

I have the calculation below but it seems to stop before the "or".

YourLockCheckBox ≠ "LOCKED" or LockQuote ≠ "Locked" and JobQuote ≠ "Locked"

I need is User 1 takes YourLockCheckBox to Locked, the record is locked to where someone with the same user privileges can unlock. Then I need to lock so that only other users can unlock.

Would switching the order in my calculation work? Since FM reads a calculation until a statement is true. Another words, if the later two are true, then FM will not read further.

Hope this makes sense.

Jimbo

I'd try using parentheses to group the And and Or the way you want them understood. Maybe:

( YourLockCheckBox <> "LOCKED" or LockQuote <> "Locked" ) and JobQuote <> "Locked"