Delete Multiple Areas

  • Thread starter Thread starter Mary M
  • Start date Start date
M

Mary M

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.
 
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
 
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?
Click to expand...

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]
 
I forgot to mention that the DB is split. Where do I make the change - in in
FE or the BE?
 
Hi Mary,

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

HTH,
Immanuel Sibero
 
Back
Top