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

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?

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

Sounds OK. I guess I'm not sure what you're trying to lock.

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

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.