Locking Records

[GrantSymon]

Hi,

how do I go about locking specific redords in 7 ?

This is what I want to do

1/

Create a new record

2/

Enter the data

3/

Lock the record.

I'd like to be able to overide the lock without too much difficulty, should I need to.

Previously I would have put a scripted button across the top of the entire record, either allowing or blocking the editing of fields, but I have a feeling that this has been improved in 7.

Is there a simple, elegant way of locking records on a per record basis ?

Any help, guidance, comments, much appreciated!

[transpower]

Edit Account | Privilege Set | New Privilege Set | Records | View only in all tables (or whatever other choice you want). Or: look at custom layout privileges.

[GrantSymon]

Hi

thanks for the reply.

Can I include this in a script in some way ?

Grant

[Computer Geek]

Grant,

You can also lock by an external variable. In the same table or a primary table, create a field Lock. When you finish data entry, have a script set it to 1. In your validation for the fields that you want to lock, have it check to make sure lock <> 1. You can script the changing of the lock to 0 to unlock the record and back to 1 to lock it again.

[GrantSymon]

Validation!! Right ... I've been hunting around all over the place ... didn't hunt in the right place. Reminds me of Winnie the Pooh. Sadly FM 7's online help is not better than it was in 6, or 5, or 4 ... seem to remember 3 was better.

Thanks,