 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008delete
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 > 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.  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Please sir, I need further explanation, step-by-step what I should do. Thanks yusuf > > 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 [quoted text clipped - 8 lines] > delete in the main table to also delete all associated records in the child > tables. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.