I have a table that lists employee names, employee ID,
Badge numbers and other info on the employee. This table
is used in multiple queries. When employees leave they
are deleted from the table. We ran into a small problem
that we actually need to have a seperate table that lists
any employee that has worked in our department wether
currently employed or not. Is there a way that when one
table is updated with new information that it
automatically updates in a second table but when
information is deleted from the first that it not be
deleted from the second table??

Any ideas??