locking a Record if Field is set to 1

[Jscott]

How can I lock a record if Field "Audit" is set to 1?

Thanks

[aaa]

You Can have list of records with "closed" fields and "edit" button before. Fore this button creat script which sends you to form of current record, where you can edit this record.

[Wim Decorte]

Different ways of doing this:

- you can use a validation calc on each field in the record that should be locked

- or in the privilege sets in your file you can set custom access rights to disallow editing when the audit field is 1

[Jscott]

What would the calculation be?

Thanks

[Jscott]

I am using FM8 and cannot find where I can set the File Privileges to lock a record if a certain field is set to one.

[mr_vodka]

Follow these menus. Steps in [ ] are actions for you to do.

File --> Define Accts & Privileges --> Privilege Sets --> [Choose the privilege set] --> Records --> Custom Record Privileges --> [Choose the table] --> Edit --> Limited --> [Put in calculation here. Case (audit<>1; 0; 1)]