Hi, I have a database with a list of products and its prices. I need the
Prices to be based on the location of the "distributor". As of right now The Prices in Houston are cheaper than the prices in new york, but they both have the prices of florida. So do I add a table to the database with the Locations? How do I go about setting different prices based on location. All I have is one price list.
How to setup database to show prices by location?
Details: