Product Database Best Practices
I'm looking to build a product database that will supply information to a purchase order database. I recall reading somewhere something about product pricing and keeping track of product prices for historical purposes instead of changing the price each time the same product is ordered over and over.
Are my thoughts on the right track? Please share what best practices you all have come up with regarding a setup like this.
Many thanks in advance.