Auto-entry problem

[Veronica]

Field1 is a number field that could contain one of several values. Field2 is the auto-entry field by calculation using the "case" function. If a user enters a wrong value in field1 and exits the field but then goes back to change the value, field2 retains the original auto-entered value. I have tried including a value in the "case" statement to blank out field2 if field1 is empty. I have tried using an "If" statement before and after the "case" statement. No luck. Is there a way to get the auto-entry field(2) to change if the user re-enters the field1 to enter a different value?

[-Queue-]

An auto-entered calculation only evaluates one time in versions below 7. You either need a true calculation field (which cannot be modified as an auto-entered field can) or a lookup using a trigger field (modification time) to force a relookup every time the data in Field1 is modified.

[Ugo DI LUCA]

And if you want both fields to have same values, even if field 2 is modified instead of field 1, you may try the double lookup trick.

here

[Veronica]

Queue & Ugo,

Thank you for your help and tips.

V