multiple locking

General Information about upcoming products, upgrades, etc.
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Mon Nov 05, 2007 5:50 am
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
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Mon Nov 05, 2007 9:26 am
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"
John Sindelar
SeedCode

Return to FileMaker Products (General)

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: