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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
I forgot to mention that the DB is split. Where do I make the change - in in
FE or the BE? |
#5
|
|||
|
|||
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 | |
|
|
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 05:07 PM |
select multiple text boxes to delete | Liglagsdad | General Discussion | 2 | November 21st, 2004 04: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 |