New at Filemaker scripting syntax. I have a table called DONORS, and a related table of all their donations as individual records called DONATION, linked by a key field donorID. I can get the sum of all donations with a calculation field in the DONORS table: Sum (DONATION::amount)
How (and where) do I create a calculation field to show the sum of all donations for each donor for a particular year. I tried creating a field in the DONORS table and tried this calculation which did not work:
If (Year (DONATION::gift date) = 2012);
Sum (DONATION::amount); 0)
Thanks in advance for any help.