Finding Related Value in a Calculation

Discussion created by cmj on Jul 9, 2017
Latest reply on Jul 9, 2017 by Jens Teich

I'm certain I've accomplished this before but can't recall how it's done. Perhaps an additional table occurrence?


Tables are related as follows: MEMBERS <---- GROUP ----> INCOME


This calculation is taking place in a field in INCOME TABLE

Case(Members::MemberRetireYear ≤ Year(Get(CurrentDate));0)


The MemberRetireYear is stored in MEMBERS Table

The INCOME TABLE does store fkMembers (it's populated via drop-down list during record creation).


How do I express in the calculation to find the record (MemberRetireYear) that relates to the fkMembers value?