Locking Fields on Condition

[ReCreation]

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.

[IdealData]

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.

[ReCreation]

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

[Johnny5]

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.

[Johnny5]

anybody?