Delete from 2 tables on 1 form
I am currently working on a charitable event database in Access 07.
I have two tables. Patron contains the data for people who have donated in the past (name/address etc.). Donations contains the data regarding their donations (year, how much, type of donation etc.)
After 3 years with no support, I wish to delete the Patron and their Donation records.
In my form I have the info from Patron which is included to ensure the correct patron is deleted and on a sub-form I have their records for Donations.
The two tables are linked in the query by the Patron ID which is included in the Donation.
All fields on the form and sub-form are set to Enabled-No, Locked-Yes.
When I click the Delete button on the form, the Donation records are deleted but the Patron record is not.
All suggestions on deleting the records from both tables gratefully accepted.
Dart players always have a point.