Return to FileMaker.com
2 tables in 1 portal
I have three tables
Donators - Profile of individuals who give donations
MonthlyDonations - Summary statement of monthly donations
Donations - Detail of donations
Layout's primary table is MonthlyDonations
Portal consist of
Donators::NameFirst, Donators:: NameLast, Donations:Date, Donations:Amount
Additionally like to have MonthlyDonations:MonthyTotal = Sum of Donations:Amount
What are the relationships linking the three tables?
Why do you need a table that is a "summary statement of monthly donations"? (Such can be generated directly from donations--simplifying your database design.)
Retrieving data ...