Delete Query

[binksmatthew]

is there any way that i can delete records from two different tables using the same delete query as i have them linked in the relationships using Member ID and if i try to delete from one of the tables then and error message appears stating that key violation has occurred.
Thanks

 

[GohDiamond]

Cascade Deletion in your relationships table will delete the related subrecords when the main record is deleted. See Tools\Relationships...; double-click on a connecting line for the related tables... you'll be able to edit relationships if you have permissions to do so and the relationship is editable (not greyed out)

For example a MEMBER is related to several monthly Membership payments. When deleting the Member without cascade delete, the error occurs because the payments would then not have a related record if the member is deleted. You could delete any payment though as those are not required. This is a one to many relationship example. 1 member has many payments.

IF referential integrity is established in the relationships and cascade delete is checked then when the member is deleted all his/her payment history/records are deleted as well.

I hope that helps,

Goh

 

[binksmatthew]

thanks. it works fine now. i tried just about everythng under the sun except that.