Help: Delete form + subform record with 1 button

[BAT40]

Hi,

I have looked on the forum but found no answer.

I have a form (employee information) with 3 related subform which records relationship between employees and different subsidiaries (work for, contract with, paid by).

What I want to do is create a delete button that deletes the form record and the 3 relationship records in the subforms.

Please help me out!

Thanks.

Bat

 

[KeithG]

If you have your relationships setup correctly with referential integrity and cascading deletes set all you need to do is delete the main record. All related records will also be deleted.

 

[BAT40]

Thank you!