delete

[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

 

[Rick Brandt]

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

That is accomplished via the relationships you create between your tables.
If you enforce referential integrity in those relationships then you have
the option to "cascade" updates and deletes. Doing the latter would cause a
delete in the main table to also delete all associated records in the child
tables.

 

[Yousoft]

Please sir, I need further explanation, step-by-step what I should do.
Thanks
yusuf