populate a table with records that are being deleted from another

[Guest]

I have a main employee table "active" - as an employee is terminated they are
deleted from the "active" table - I would like for this deleted record to be
stored into my table "terminiated"

Thank you
Chris

 

[Guest]

Don't do it! Instead of deleting the employee and moving records to a
different table, put a Yes/No field in the table called something like
Terminated. When the employee is terminated, put a checkmark in this field.
Change all your queries, forms, and reports to exclude these Terminated
employees.