statsman
Active member
- Local time
- Yesterday, 23:27
- Joined
- Aug 22, 2004
- Messages
- 2,088
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.
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.