Archiving related tables ?????

  • Thread starter Thread starter Andrew T
  • Start date Start date
A

Andrew T

I have a prospects database that uses on-to-many related
tables.
When a prospect is 'dead', I want to archive the record
and records in the related tables to an Old Prospects
database. The Old Prospects database has exactly the same
structure.
I can't find a way of archiving selected records. I have
tried using an Update Query but this only seems to address
one table at a time.
Any Suggestions please ?
 
Back
Top