Archiving of sorts...

[Guest]

Hello, when there is a record in our system that we're done with, we tick a
box on it called dead, we dont want it to get deleted but how would i go
about designing it so that when the dead button is clicked it moves the
record into a 'dead' archive just to keep it seperate from any current
jobs.., thanks, WK

 

[Rick Brandt]

Hello, when there is a record in our system that we're done with, we tick a
box on it called dead, we dont want it to get deleted but how would i go
about designing it so that when the dead button is clicked it moves the
record into a 'dead' archive just to keep it seperate from any current
jobs.., thanks, WK

It would be better to just set up your queries to filter those out and leave
them in the same table.
As long as you index that field it will be just as fast as removing them from
the table.