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