>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.