I have a I'm attempting to make a Database to record product sales. so far my relationships look as follows: Products-=Product Price Records=-Distributors.
I want to add a Sales table but I can't figure out which other table to relate it to. the products are sold at different prices depending on the distributor- so do I relate sales to the Product Price Record, or the Distributor- because it's really important that the sale is recorded at the correct price by the correct distributor.
I want to be able to see not only what sales each of my distributors has made, but also what total sales for each Product. I've spent many hours puzzeling over what I thought should be a simple database.