Using Append Delete Queries in Relational Databases (1 Viewer)

[rhounsome]

If I create a delete query in a relational database and delete the main record all related records from linked tables to this record disappear, which I can understand due to the relationship between them.

How do I set up a query to append all this information to related tables to a set of tables prefixed Deleted.

Example

Main Table

Linked Tables

Table1, Table2, . . . ., Table5

Do I have to create seperate queries for all the tables I wish to append information from?

 

[SimonC]

If the relationship between the tables is one-to-one, you can append into multiple tables simultaneously by appending into a query (which joins all the tables together). Where you have a one-to-many relationship, you really have to append the data separately.

Simon