Delete Multiple Areas

[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.

 

[Immanuel Sibero]

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

 

[John Vinson]

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]

 

[Mary M]

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

 

[Immanuel Sibero]

Hi Mary,

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

HTH,
Immanuel Sibero