first time posting.
I have created a table to help me price jobs more effectively and I have effectively created a list of materials, costs with and without VAT, it all totals up and is working well.
What I would like to be able to do now is having added the quantities for a particular commission then move this materials and quantities to a new table with that customers name and have it remain and not change when I alter the master. That way I can keep an accurate costing for individual customer and amend just their record when I need to. Does anyone have the time to help me.
It sounds like you now need a new table to hold your People (customers, sales?) and a table to hold your orders. The orders table should link to the People and the Materials. Once this is set up and there is data, you can use RollUp to run a formula on how many Materials a Person ordered.
Thanks so much for taking the time.
So if I create a table for each customer for example, surely I can add lines from my materials table to it somehow. And then I can amend the quantities within the customer table.
In the customer table I can then add in my overheads and labour costs and hopefully generate a genuine and repeatable cost based method of pricing my furniture. you help is much appreciated.