A
Alvin Smith
I have a products table the headings are " Product ID , Product Name & Unit
Price.
My question is. I have 5 different buyer levels. LVL1, LVL2, Buying
Groups, Distributor & Retail sales and they all pay a set price for each
product according to their Level. How can I set this up without having 5
different databases like I have now? I want to keep an Inventory and that is
working but only in each individual database. I can select a customer and set
his Lvl but I cvan't get the price to change accordingly.
Price.
My question is. I have 5 different buyer levels. LVL1, LVL2, Buying
Groups, Distributor & Retail sales and they all pay a set price for each
product according to their Level. How can I set this up without having 5
different databases like I have now? I want to keep an Inventory and that is
working but only in each individual database. I can select a customer and set
his Lvl but I cvan't get the price to change accordingly.