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
> 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.