Finally, she tested the query that had broken everything last year: "Total Pledges for the Harvest Dinner, grouped by Donor City."
She ran it.
At 2:00 AM, she built the interface. She used the to create a main form based on tbl_Donors and a subform based on tbl_Donations . Now, when she scrolled through a donor, all their past donations appeared instantly in a tidy datasheet below. 7.3.9 database design in microsoft access