Locking fields when "x" condition is met

[Rich S]

Howdy, howdy:

I'm having a problem trying to nail down a calculation, so here goes:

1) Say I have three fields, "A", "B", "C", and a Date field. Fields A, B, and C must be filled in before FM will allow me to enter a date in the Date Field.

Once a date is entered in the Date field, I want FM to prevent changing of the data in fields A, B, and C. (The problem I'm having coding it as a calculation is that FM prevents me from changing a calculated value.)

Could I set up a "lock" calculation to prevent changing of the data in fields A, B, and C _and_ the Date field? When the record is "unlocked", the Date field will be editable and when the date is removed, fields A, B, and C will be editable.

How do I code that--as a script, a calculation, or...?

TIA for your help!

Rich

[Vaughan]

"How do I code that--as a script, a calculation, or...?"

It's a calculation, but it's done in the Accounts and Privileges.