Old Records

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

Currently I have a training database. I have old records in it that I would
like to delete but my management is totally against that. I really don't want
employees in the database that have left our department, I was wondering if
there are any recomendation on how to deal with this situation besides
leaving the old employees in there.

Is there a way to make it easy to import the employees and their records for
employees that have left or who are leaving to another database so I will
have only current employees in my active database.
 
You could put an Active flag on each record, setting it True or False, then
write a query that only returns those records where the flag is True. You'd
then use that query rather than the table.
 
It is quite common to leave old records in the same table as current ones.
Recommend you add a YES/NO field called "Old" or "Inactive" and then, instead
of using the Employees table, use one of two queries:
SELECT * FROM Employees WHERE Inactive=FALSE
or
SELECT * FROM Employees WHERE Inactive=TRUE

Federal/State agencies often requires you to provide info about both old &
current employees, and this system gives you a very convenient way to do that:
SELECT * FROM Employees WHERE <<whatever the govt. agencies require>>

The alternative of splitting old/current into two tables, then combining
them for special requirements that need both, involves much more programming
for moving records between tables.
 
Concur with other posters and add that many employees return and you would
want their training records.
 
Back
Top