My website is about e-commerce. The problem I have here is if I delete a product in Product Table (Access), the data that store ProductID in OrderDetail Table will be automatic delete also. I need to store Product's Info (like ProductID, SKU, ProductName) so I'll know what I've sold. Please give me some advice and sorry for my bad English.

Don't delete the record - create another field for In Stock / Out of Stock - don't display the record if it's out of stock.

Regards,
Brent

Thank you so much for your advice.