Lock field if another not IsEmpty

[DB_Noob]

Help. Sorry, I've seen posts about this but for some reason, they don't seem to help me.

Simplified:

Fields:

APPROVED

CONTRACT_PRICE

CONTRACT_PRICE is typically editable.

But, if APPROVED is checked, or not IsEmpty or whatever,

CONTRACT_PRICE becomes not editable.

*I am not using buttons to initiate any scripts. *I'm assuming I can do this as a calculation w/in one of the the two fields.

*I don't know where and I don't know what functions/language to say "Don't make this field editable anymore".

Thanks a bunch.

[mr_vodka]

There are a few ways to do this... One would be with field level access privileges under accounts and privileges.

Another would be to make your CONTRACT_PRICE field a button itself. It would then call a script like.

If [ not IsEmpty ( APPROVED ) ]

Show Custom Dialog [ "Locked"; This field is no longer editable" ]

Else

Go to Field [ "CONTRACT_PRICE " ]

End If

A possible third option would be to use some kind tab control to hide the field.

Yet another option would be to use a relationship to hide the field.

[DB_Noob]

Thanks a million. That whole making fields a button thing really threw me off and is totally new to me. I didn't realize you could do that. That is going to really help with other files I'm making.

And it works by the way.