Page 1 of 1

Lock a single record

PostPosted: Tue Oct 30, 2007 7:31 am
by jim shelton
In 8.5, I need to lock a record. I have used IsLocked but that locks all the records. Is my only option a vaidation by calculation?

Help is appreciated.

Jimbo

PostPosted: Tue Oct 30, 2007 8:33 am
by John Sindelar
No, you can use Access Privileges to lock the record as well (to prevent editing in some cases) though I always accompany this by some on-screen indication that the record is locked (an unstored calc with a "locked" message) so that users aren't always trying to edit locked records.

The message tries to prevent them from editing the record and the Access Privilege enforces that.

Would that work for you?

Custom Record Privileges

PostPosted: Tue Oct 30, 2007 11:18 am
by jim shelton
I have this Customer::YourLockBox ≠ "LOCKED" as a Custom Record Privilege under limited. Is this what you are speaking of. This locks all records for that customer.

Jimbo

PostPosted: Tue Oct 30, 2007 11:38 am
by John Sindelar
Sounds OK. I guess I'm not sure what you're trying to lock.

PostPosted: Tue Oct 30, 2007 12:08 pm
by jim shelton
I want to lock a single record (job ticket). The record has the clients name, email etc, from the Customer table. When you make YourCheckLockBox = Locked, it locks all records for that customer.

Since each record for that customer is connectd by the Customer table, does that mean when one locks all must lock.

Our goal is to lock the record when job is billed so information does not become accidentally changed.

So is there another way, lets say if Job Status = "Billed" record becomes view only.

Jimbo

PostPosted: Tue Oct 30, 2007 12:18 pm
by John Sindelar
jim shelton wrote:lets say if Job Status = "Billed" record becomes view only.


Looks like that is the access privilege calc you want to use in the Jobs table.