We want a record that is marked 'Completed' to be locked and not editable. Does anyone have a good way of doing this?

Thanks in advance.

File | Define | Accounts & Priv | Priv Sets | New | Records | Custom Record Priv | Set | limited | IF(Field = "whatever")....

That will lock down the record if that criteria is met in that field..... Be careful! Once you set the field you cannot get into the field to change it because ...well...you've locked the fileds with itself! Exclude that field from the lockdown or make a script setfield to change.... practice with a new test database first.....and always!

Royce

Thanks Royce that works.

Actually, why is the edit one grayed out? We would really like the person to be able to see the record with status completed, but not be able to edit it. Any ideas?

Thanks again.

Nevermind I just figured it out.

You have to set privileges to view the record before being able to set the privileges to edit.

Thanks again.

Edited January 31, 200719 yr by Guest

HI their,

I got similar request but on my case! After complete the form at the end I need to lock the record which is locked by user and if necessary administrator will do changes. That means administor will reopen the record for editing purpose.

Any trick? advice will appreciated.