so for every new invoice (CH001, CH002) in table 1 add three lines for that invoice in table 2
So if you have
CH001 Marianne £4050 29/03/14 Mesh
and you want to add to another table
row 1:1 CH001 invoice for £4000
row 2:2 CH001 invoice for laundry £50
row 3:3 CH001 any queries please contact
How do you work out the split of £4050 into the two separate amounts and how do you determine that one amount was for laundry?
No, you haven't explained it clearly.