Computer Disposal Best Practice: Table to Store Retired Hardware?

[scouser]

Hi guys. I have been working on a database to store network information, computers, software etc......

I have a table (tblComputers). I allocate computers to users on the network.

My question. When they come to the end of their shelf life I have the option to delete them from the database. However once deleted I will have no record of them. So I thought......would it be better to create a seperate table and move them there, or add an additional check box within tblComputers 'Retired' then add some code to prevent allocation?

Advice warmly received as always.
Phil.

 

[Dennisk]

scouser (l'pool lad myself)

Create a deleted Column Yes/No in the table and just flag as deleted. Although you may have to revamp queries/reports.

Then create a simple continious form to display deleted records. That way you can then easily undelete the record

 

[scouser]

Thanks

Thanks, I will look into that tomorrow.

I must confess that I am a soft southener........my dad is a scouser, lives in Bootle......can never think of a good name for forums so tend to use Scouser!!

Red thru and thru mind
Phil.