>>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?
>
>Show them, of course - they WERE in use in the period shown, weren't they?
>
>You may mark them somehow (I've seen prefixed them with asterisk, or greyed out) if 'deleted'. Or suffixed with "[discontinued]" or some such.

I agree with your logic that since the items WERE used at some point, they have to be shown. And I will see how to "mark" these items differently.
Thank you!