A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Delete Multiple Areas



 
 
Thread Tools Display Modes
  #1  
Old February 1st, 2005, 09:39 PM
Mary M
external usenet poster
 
Posts: n/a
Default Delete Multiple Areas

If you have a DB setup with a main table linked to a one-to-many table. Is
there a way to delete a record from the main table and have all the one to
many records in the other table be deleted with it at the same time?

Many thanks for any assistance.





  #2  
Old February 1st, 2005, 10:21 PM
Immanuel Sibero
external usenet poster
 
Posts: n/a
Default


Hi Mary,

Use the Relationships menu to establish this One to Many relationship. While
you're at it, check the option "Cascade Delete".
Cascade Delete exactly the answer you're looking for.

HTH,
Immanuel Sibero



"Mary M" wrote in message
...
If you have a DB setup with a main table linked to a one-to-many table. Is
there a way to delete a record from the main table and have all the one to
many records in the other table be deleted with it at the same time?

Many thanks for any assistance.







  #3  
Old February 1st, 2005, 11:21 PM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Tue, 1 Feb 2005 15:39:46 -0500, "Mary M"
wrote:

If you have a DB setup with a main table linked to a one-to-many table. Is
there a way to delete a record from the main table and have all the one to
many records in the other table be deleted with it at the same time?


Yes; open the Relationships window and select the join line. Check the
"Cascade Deletes" button.

Just be aware - when you delete a record in the "one" side table it
gives you *one* warning (and even that can be turned off). If you
click OK those records are GONE and cannot be recovered, period, once
you move to a different record or close the database.

John W. Vinson[MVP]
  #4  
Old February 2nd, 2005, 05:19 PM
Mary M
external usenet poster
 
Posts: n/a
Default

I forgot to mention that the DB is split. Where do I make the change - in in
FE or the BE?



  #5  
Old February 2nd, 2005, 05:51 PM
Immanuel Sibero
external usenet poster
 
Posts: n/a
Default

Hi Mary,

Make the change where the tables are (i.e. the Back End)

HTH,
Immanuel Sibero


"Mary M" wrote in message
...
I forgot to mention that the DB is split. Where do I make the change - in

in
FE or the BE?





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why get multiple copies of file when try to delete ucsd General Discussion 2 January 17th, 2005 06:07 PM
select multiple text boxes to delete Liglagsdad General Discussion 2 November 21st, 2004 05:43 PM
Deleting Records does not Delete Records Lucky Man Cree New Users 7 July 6th, 2004 11:33 PM
Multiple Many-To-Many Tables Tom Database Design 7 May 15th, 2004 03:47 AM


All times are GMT +1. The time now is 11:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.