Append query problem

[BabyATX13 via AccessMonster.com]

I have a database that is just huge, and at some point in time the company
will have to archive the data in the tables, for the most part I can do this,
the problem is with my linked tables. I don’t know how to archive them all at
once.

Example

Invoice table:
InvoiceNo Auto Number Primary Key
DateFrom Date/Time
DateTo Date/Time
CompanyName Number

15 Blling Tables:
BillingID Auto Number Primary Key
InvoiceNo Number
And some other irrelevant stuff, all different from table to table, depending
on the billing type.

All 15 Billing tables are linked to the one Invoice table by InvoiceNo. My
problem is, I am archiving the invoice table by date and I want the linked
Billing tables’ information to go with the invoice number for those dates
that are archived. I now realize, had I thought of it years in advance, that
a date field in the billing tables would have been helpful, but it is too
late to fix now, as there are thousands of records in them now.

Any help on this matter would be greatly appreciated.
Thank you,
K Board

 

[Guest]

Try linking BillingID to DateTo as BillingID is related to InvoiceNo in
Billing table and InvoiceNo has a DateTo in Invoice table.

 

[BabyATX13 via AccessMonster.com]

Actually InvoiceNo in Invoice table is related to InvoiceNo in Billing table
One invoice will have many billing details.

Try linking BillingID to DateTo as BillingID is related to InvoiceNo in
Billing table and InvoiceNo has a DateTo in Invoice table.

What will that do for me?