Append ALL Related Fields

  • Thread starter Thread starter i.am.lost
  • Start date Start date
I

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).
 
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.
 
Back
Top