Thread: Back up
View Single Post
  #3  
Old April 28th, 2004, 05:13 PM
external usenet poster
 
Posts: n/a
Default Back up

I need a different table because I need to link the
employee information of current and past employees in
queries. We still need the origional table for other
queries.

Thank You
-----Original Message-----
wrote in message
...
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??


Deleting the records from the table is probably wrong -

it might be better
to set a flag saying "this guy has left" and use this as

a filter when doing
queries that only want to see current employees. Why do

you think you want a
different table?

--
Tim Ward
Brett Ward Limited - www.brettward.co.uk


.