On Wed, 21 Apr 2010 11:31:01 -0700, Gil Silva
wrote:

Thanks, John
DB Design is not my strong point. But I am learning. I will stop deleting
records to keep the database stable. It probably would be better to append
the ID, Names, and Date of Class to a different database altogther if it can
be done.

Sorry, but creating an entire new *DATABASE* would be substantially worse than
just deleting the records.

Just put a field in the table indicating whether the employee is current or
not.
--

John W. Vinson [MVP]