Append ALL Related Fields

[i.am.lost]

1-many relationships exist between tblCampaign -> tblAdvert -> tblTask (so a
campaign can have many adverts, and an advert can have many tasks).
I have created an append query to archive old campaigns.
However, I want it to also append all related records in tblAdvert and
tblTask.
Essentially, I am trying to recreate the Cascade Delete Related Fields
option except I want Access to append all the related fields to specified
tables (rather than delete them).

 

[KARL DEWEY]

A better method is to add a Yes/No field named Archived and add criteria to
your queries that Archived = False or 0 (zero).
This technique makes all records available when you need to include history.