Delete sub-form records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yousoft - 19 May 2008 06:25 GMT

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

Reply to this Message

Steve Schapel - 22 May 2008 10:54 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> 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

Reply to this Message