Hi there,
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.
Thanks so much in advance.