I have developed an application in Access 2000 to record all the microbiological data for a laboratory.
What I need now is to calculate the cost for each analysis (each analysis is consisted from many parameters with different cost for each customer.
What I have so far is :
Customer table : with the cost for each parameter
Order table : details for each order, customer name, type of analysis and relevant parameters.
What I think I need is during the input of the data to have a macro or function which will distinguish the specific parameter for the specific customer and update a field in the order table using the value from the customer table.
Please help
What I need now is to calculate the cost for each analysis (each analysis is consisted from many parameters with different cost for each customer.
What I have so far is :
Customer table : with the cost for each parameter
Order table : details for each order, customer name, type of analysis and relevant parameters.
What I think I need is during the input of the data to have a macro or function which will distinguish the specific parameter for the specific customer and update a field in the order table using the value from the customer table.
Please help
