How to hide records that are no longer needed?

[emtau]

Greetings good people,

I would like to take up your time if you could lend a hand in helping me on how to hide records that are no longer needed.

To be more specific, I created a database with employees record in it. Any new employer will be put in the database and update his/her profile. My question is if an employee is no longer working with us, we want to keep his record but somehow exclude him/her/them from the current working employees.

Options that came through my mind is that I could mark them as EX-EMPLOYEE on their photo in red or something like that but that would still include them with the current staff. So I want to hide them permanently like they've been deleted but when needed, we can show them who were they with all their past records still intact etc.

Any ideas?

Thanks.

[Ron Cates]

Use a field called something like status with a value of 1 if active or 0 if inactive. Then you can easily use this field in filtering or find requests to exclude inactive records.

[comment]

6 minutes ago, emtau said:

My question is if an employee is no longer working with us, we want to keep his record but somehow exclude him/her/them from the current working employees.

I would suggest entering a date in a DateTerminated field when an employee leaves. Then you can add this as a condition to any find.

[emtau]

Good one guys. I will try and to pick up ideas from your suggestions....keep them coming.