Price Lists

[Nick Bradbury]

Hi

I have a database that I use to raise Lab Orders record results and print
off invoices when tests are completed. Until now prices have been per test
and standard for all customers so I included the cost in the tblTest and
this has been OK, however we are about to introduce a larger product range
and want to create a price list on a per customer basis. Do I need to create
a separate tblPriceList with a record for each test for each customer (a lot
of work) or is there a more elegant solution (less work).

Any ideas greatly appreciated.

Many thanks

Nick

 

[Joseph Meehan]

Hi

I have a database that I use to raise Lab Orders record results and
print off invoices when tests are completed. Until now prices have
been per test and standard for all customers so I included the cost
in the tblTest and this has been OK, however we are about to
introduce a larger product range and want to create a price list on a
per customer basis. Do I need to create a separate tblPriceList with
a record for each test for each customer (a lot of work) or is there
a more elegant solution (less work).

I would guess there are going to be a few standard price list and each
customer will be assigned to one of those price schedules. That would only
require a single reference in each customer's record to reference the price
list.

Note: you need to consider what happens when the prices change and when
a customer changes from one price schedule to another. How will that change
old current and new records?