March 31, 200124 yr 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!
April 20, 200124 yr 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.
April 20, 200124 yr 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."
April 23, 200124 yr 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.
Create an account or sign in to comment