AnsweredAssumed Answered

Relationship Trouble

Question asked by mary7800 on Oct 13, 2008
Latest reply on Oct 15, 2008 by mary7800


Relationship Trouble


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.

Please Help!