Presumably you have this relationship between Donors and Donations:
Donors::__pkDonorID = Donations::_fkDonorID (though your field names may be different from mine.)
and you are defining a calculation field in donors to show whether the donor is or is not late for their next donation.
That matches what you have described where referring to a field in donations from the context of Donors refers to the first related donation record.Case(DonorFrequency = "Monthly" and ( Get ( CurrentDate ) - Last ( Donations::DonationDate ) > 31 ) ; "Late" ;The other cases will be the same except for the number of days used in the calculation.
That works great, thank you so much!