Delete sub-form records

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
 
S

Steve Schapel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top