Hiding Records without Deleting them

Deleting records is permanent and when e.g. you delete a Customer, all related records are deleted as well. This will obviously affect your reporting. Sometimes you might want to disable e.g. a Customer or Operator so that they can't be used.

To do this you will need to open the database in the relevant tool and update a record manually. Most tables in the database have a column named Deleted. Normally this is set to 0. To disable this record, set the value to 1. For example, to hide a particular Customer, open the Customers table, locate the Customer record you wish to disable and set the Deleted value to 1. You can do this for Customers, Departments, Contacts, Operators, Assets, Asset Types, Categories and Prioirities.

Home