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?