I've been searching the forums like heck to no avail.

Can some one point me how to Prohibit edit of a field if a value exists.

I thought it was as simple as checking the Validate existing value box in the Validation Tab but unfortunatly its not as simple as that.

Thanks

Typically, when someone has this request, we suggest setting the field's behavior to not allow Browse mode and putting an Edit button next to the field. The Edit button would run a script that would popup a layout that has the field(s) open for edit, providing the validation part of the script was true.

That is,

User clicks Edit

Script starts

//validation check

If (isempty (field))

gtrr in new window using layout Edit

else

//validation fails

Show Dialog "Sorry, you can't edit this field."

endif

You could also tie the allow edit to a priv set, such as Admin only by checking Get (PrivilegeSetName) = "Admin"

Thanks. Is there no way to do that via a calculation in Validation Tab?

Perhaps. I don't use the Validation tab for something like this, because the interface options are hideous.