Delete sub-form records

  • Thread starter Thread starter Yousoft
  • Start date Start date
Y

Yousoft

I have one main form linked with many sub form, my problem if I want to
delete one record, it delete only form the main form table so when you open
another table you will find same record still there in another tables so what
I will do to delete the records from all tables in the same time.
Thanks
 
Yousoft,

One approach to consider here, go to Tools|Relationships, and define
Relationships between the main table and the tables that the subforms
are based on, with Referential Integrity, and Cascade Deletes. That
way, if you delete a main table record, all related records in the
linked tables will be automatically deleted.
 
Back
Top