deleting all records from subforms

[furnitureheaven]

Hi,
I have a main form and multiple sub forms in my project, main form and sub forms have primary and foreign key relationship. I want to delete a record from main form, this should also delete all records (related to that reference no) from the all sub forms.
I have tried different tricks but it only delete one record from first sub form (i.e. delete first record but not deleting all record)

I also have attached a sample project for a look.

Thanks in Advance

 

[Banana]

If you have relationship defined, just tick "Cascade Deletes" in the relationship definition.