>>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!
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham