I already use the second resource for 'Grouping', this way I just see a sub set of my employees - just electricians, managers, office staff, etc. However, I never want to see Inactive/Ex-Employees, so I need a way to filter these people out.
I've tried deleting Ex-employees from the systems but it won't let me do that either, the system says that you have to turn employees inactive if they have modified records in the system.
So I need a solution, as our database gets larger I don't want to sift through old employees.