I created an employee database with a table that has my employees in it. I split the database (reg. file and be file) to make transferring easier. Of course in the nature of business I will lose employees. I do not want to delete an employee because if I want to reprint an old time card the past employee will not show up if deleted.
How can I make it so when an employee leaves the company I can still keep him in the employee table but when the form selects from the table ans shows all the employees in the timesheet form, the past employees name(s) will no longer appear?
The only way that I will see the old employee(s) is if I reproduce an report from the past or if I go into the table itself.
Hope I explained it correctly.
Thanks,
Scott Munkirs