Hi,

I am looking for an input for a good (or bad) practice.

Here is the situation. The application has Parts table (nuts and bolts). When a user post a usage of this or that item, a record is added to a Parts Usage Table. There is a report that shows, for a selected period, all items used.
When user deletes a part record from the Parts table, the application does not actually delete the record but hides it (by setting a field REC_ID to 'D'). So as far as the user, the record is gone.
The Parts Usage Table is not affected by a user's deleting a record. The report of usage may or may not show the items used. I can "filter" out the items set as "deleted" or show them in the report.
Which would you recommend? Exclude or show the "deleted" items?
TIA