Archiving Data from Multiple Tables

[Tina49]

I have a database with employees. The tables are as follows:

Deptdatatble
Depttble
Emptble
HRtble
Servicetble
Servicedatatble
Archivetble
Classestble
Classdatatble

At certain times, I want to archive employees out (lets say they are terminated). When I do this, something strange happens. If an employee has 4 records in the servicedata table and 4 records in the Classdata table, then it exports out 16 records (4 x 4). Why is this? I would expect it to export out 8 records.

 

[Tina49]

I will give that a try Pat. So any type of one to many relationship needs to be exported separately then.
Can I create a query for each one and then put both queries in the append query? Or will I still have the same issue?

 

[Tina49]

I was just going to have them go into one table called archive. I had already created a form that would put the information together so if they needed to see the archived data they could. Perhaps though it would be beneficial to have the information in the original archived tables. I do have 4 tables they would have to answer messages to, or I guess I could suppress the messages.

 

[Tina49]

Moving the files into archived tables worked great! I decided to leave messages on, so that they don't delete archived employees that never officially archived (In case of error). Thanks again for all your advice!