Suppose this database
"C" and "C 2" are occurrences of table C
the field "test" is an unstored calculated field where its calculation is "Last(B::CID)"
On layout A you would normally get
Now let's delete the last record in table B and go back to layout A
C 2::CID =2
If I refresh the layout I get the correct result of C 2::CID=1
Now....why do I have to do a refresh ?
I don't want to.
I should not have to.
Any way to always get the correct value of C 2 without using a refresh ?
I can get it to work without a refresh with a calculated field based on other occurrences of A and B but I don't like adding occurrences just for simple field.
The example above does not make much sense but it's just to illustrate the problem I have