I am trying to find a way to lock database record fields in a layout for a work management system I have created so that when a certain field is completed with a YES value (a quality control field in the database), that the other fields in the record layout I am using will not be able to be altered. I guess this is a script function of some kind. I appreciate any help or guidance anyone can give me. Thanks.

Have a look at the Privilege Sets in File > Define >Accounts & Privileges.

There's a way to set LIMITED RECORD ACCESS and you can set the condition based on data in the current record, ie your YES value.

Thanks so much!!! Funny how you don't see options that are right in front of you.

I looked at the define accounts and I do not see a way to lock fields on a condition. How do I lock certain fields from being entered upon a field called, Lock_Fields being set. I do not want to lock all of them but only some.

anybody?