referencing a related field

[David Jondreau]

I know, I know, Filemaker can't monitor related fields so you can't store a calculation with a related field in it. But when the related field is the result of a Case() statement, it seems to me like that should be storable.

The calculation Case( localField = 1; relatedField) can't be stored, but that calc doesn't require monitoring, it's triggered.

Anyway, a field with an auto-enter calc seems to work just fine. Just ranting.

[comment]

Case() or not, the formula requires the value from the related field in order to return the correct result.

[David Jondreau]

:lightbulb:

[color:black]I don't know why that was such a puzzle for me. Thanks.