I have two tables Donators & Donations. There are multiple donations to a donator.
I'd like to calculate the following based on each donator and store result in donator table
Fields are as follows
Donator::SumTotal, Donator::SumAvg, Donator::DonationTotal, Donator::LastDonation
Donations is a portal within the Donators Layout
Total Number Donations
Smu total of all donations
Date of last donation