HI All,

Basically I need a stored field to be recalculated every time the file opens.

I have table1 with calculated field1=0 then I have table2 and calculated field2=If(someField>Get ( CurrentDate );0;"")

Field2 has to be stored because table1 and table2 are related by table::field1 and table2::field2

The problem however is that because field2 is stored it will always give back the same value (as it was when it was created) regardless of "If(someField>Get ( CurrentDate )"

So basically I want to force a recalculation of field2 every time the file is open

Any help will be very much appreciated!

Amram Chayim Eirinberg

It would be much better to solve the real issue here:

1. Change the calculation field to =

Get (CurrentDate)

(set the result type to Date and make sure it's unstored)

2. Change the relationship to:

table::field1 > table2::someField

Thanks comment