Copy Record from one table and its related records from another table into 2 new tables
This is my problem I have 5 tables Proforma and its related table LineItemProforma and Table Invoice and its related table LineItem. Table Client is connected to both Proforma and Invoice. My question is how can i copy selected ( current ) record from Proforma and its related records from LineItemProforma to table Invoice and its related records to LineItem.
Or to explain more precise. I have an proforma for a client that contains products and prices.On the proforma layout i have an button that will contain script that will make copy of the proforma and products contained in that proforma to the table Invoice with the same products.
So the Invoice must be copy of Proforma , but in different table and different layout.