Delete Record best practice

hello guru,

actually this is a general Database question,

i wonder how to implement record deletion in a table,

if for example i delete a record in the 'Product' table, then when a user wants to see the 'Monthly Sales Report' there could be an error if the Sales table has a reference to the record in 'Product' table that has been deleted. and also in this case, it doesn't seems right to CASCADE the deletion to the any other table refererencing this record.

Thank you!