Products with different price ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 5 different buyer levels. All can purchase the same products but each
Buyer pays a different price according to their buying level. I am totally
lost on hbow to set this up without having 5 different Databases.
 
Table 1: Buyers & Buyer Level
Table 2: Products, Price 1, Price 2, Price 3, Price 4, Price 5

You should be able to link the buyer level to the right price. If the buyer
level is simply a discount based on a mathematical equation, the tables would
be even simpler.

Hope that helps.
Howard
 
Back
Top