Query/Table problem

[Bickertk]

I have in my database a car table, linked to this by ID is an accident table and a defect Table.

I have made another table in which I place records for vehicles not current by an append query, i,e, car table history.

If I make history tables for the Defects and Accidents can I make the one query to move all this information at once as it is connected . If so, How?

Thanks for any help

 

[GingerR]

you would use three different append queries to copy the 'old' records into the history tables. Do the MAIN table first. Then the other two.

then, if you have the relationships set up correctly - these two selected in RELATIONSHIPS: Enforce Referential Integrity and Cascade Delete Related Records - then when you delete from the MAIN table, the message will say that records from other tables will be deleted too, to which you answer OK.