What is the best to mark a record active or void??

[synergy]

What is the best to mark a record active or void??

Inorder not to be deletd records but be able to sort through active "quote requests" (the db is an on-line quoting system) and the void ones would signify records that have been delt with. Please note that access to voiding a record must be controllable via user log-in. And also that much of the db layouts use portals to view many records at once. i would like to add this next level of refinement (active/ void) for clarity. Any help will be greatly appreciated!

[JohnnyC]

I add an Archive check box field to any db where I want to void an item with erasing it. Then I omit those records under normal finds or drop them to the bottom of a list by sorting by the check box first. You can set up the field to be password protected so only you can archive it.

[JohnnyC]

Sorry, hat last post should read "I add an Archive check box field to any db where I want to void an item withOUT erasing it."

[Lee J]

I to do the same for our Work In Progress lists. the conditions are "Dead/Alive" this is based on Status selection. All jobs are "Alive" unless the Status is changed to "Completed" then they are Dead.

This works well for us as we often recall jobs later on for additional changes.