Fields problem

[thierry.be]

Hi,

I am looking for a solution for the following problem:

- I have three fields.

date

revised date

freeze

Freeze can have value yes or no.

In the layout the user cannot edit 'date'

Case 1:

Freeze = no

If the user changes the value of revised date, the value of date should also change.

Case 2

Freeze = yes

Whenever the user changes the value of revised date, the date should remain the same.

Does anyone have an idea of how to implement this?

Hope someone can help me ,

Thanks, anyway.

[danjacoby]

Off the top of my head:

Create another field, let's call it "CorrectDate". Set the fields "Date" and "CorrectDate" so that data cannot be entered. That way, the only fields in which data can be entered are "RevisedDate" and "Freeze". In fact, change Date to a calc field, where it equals RevisedDate if Freeze equals "no", and CorrectDate if Freeze equals "yes". Finally, create a script that runs automatically when the file closes that resets all records so that CorrectDate equals Date (use the "SetField" command).

This way, every time you open the file, in all records Date will equal CorrectDate; any revisions made during the session will update CorrectDate as necessary for the next session.

That's one way; there are almost certainly others.

[thierry.be]

This works just fine,

Thanks you,

Thierry