Form/Subform Question

[Salisha Khan]

Hey everyone,
I have a form and subform and on the main form I have a delete button.
This button was created with the command button wizard. When I click on the
delete button, I would like the entry on the main form and it's
corresponding entries on the subform to be deleted, but this doesn't happen.
The entry on the main form is deleted from the table, but the subform
entries are not deleted. How can I rectify this problem? What am i doing
wrong? Please help!
salisha

 

[Rick Brandt]

Hey everyone,
I have a form and subform and on the main form I have a delete button.
This button was created with the command button wizard. When I click on the
delete button, I would like the entry on the main form and it's
corresponding entries on the subform to be deleted, but this doesn't happen.
The entry on the main form is deleted from the table, but the subform
entries are not deleted. How can I rectify this problem? What am i doing
wrong? Please help!
salisha

You could define that you want cascading deletes in the tables relationships and then
the child records would be deleted automatically regardless of where you did the
deletion from.

 

[Salisha Khan]

Hey Rick,
Thank You! That worked perfectly!
salisha