M
mc
Hi,
I am trying to create a database which generates a Sales
Order form. Product prices are automatically "called up"
when the user selects a particular product.
The problem I'm facing is that although I have a master
price list, the prices differ from customer to customer.
E.g. Customer A may buy based on master price list, but
Customer B is a special customer and buys based on a
discounted price list.
Should I make use of fields in the master pricelist table
for different customers? I have 50+ customers with
different pricing, so any limitation to the number of
fields per table?
If I were to use different tables for each customer, how
can I lookup the prices on the Order Form? (e.g. user will
first select the customer, then select product).
Many thanks!!
I am trying to create a database which generates a Sales
Order form. Product prices are automatically "called up"
when the user selects a particular product.
The problem I'm facing is that although I have a master
price list, the prices differ from customer to customer.
E.g. Customer A may buy based on master price list, but
Customer B is a special customer and buys based on a
discounted price list.
Should I make use of fields in the master pricelist table
for different customers? I have 50+ customers with
different pricing, so any limitation to the number of
fields per table?
If I were to use different tables for each customer, how
can I lookup the prices on the Order Form? (e.g. user will
first select the customer, then select product).
Many thanks!!