sfpx

Occurrence not refreshed

Discussion created by sfpx on Jan 9, 2017
Latest reply on Jan 10, 2017 by electon

Suppose this database

occ.png

where

"C" and "C 2" are occurrences of table C

the field "test" is an unstored calculated field  where its calculation is "Last(B::CID)"

 

Data

Table A

AID=1

 

Table B

BID=1, AID=1,CID=1

BID=2, AID=1;CID=2

 

TABLE C

CID=1

CID=2

 

 

On layout A you would normally get

test =2

C 2::CID=2

 

Now let's delete the last record in table B and go back to layout A

 

We get

test=1

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 ?

 

Note #1

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.

 

Note #2

The example above does not make much sense but it's just to illustrate the problem I have

Outcomes