AnsweredAssumed Answered

Copy a table to another

Question asked by tanja on Nov 1, 2018
Latest reply on Nov 1, 2018 by edwardlscott



I have an invoice table. I spend one more table called "offers".

If a customer says ok to the offer so the offer for that customer should become an invoice.

How can I copy all of the relevant tables?


First, I think about to handle the offers in the same table (invoice) and spent a field called "is_offer" to seperate the difference. But it is too complex now to handle that.


So I have decided to clone the invoice table and their structure of TOs and make an "offer".

Afterwards I will copy all the contents to the invoice table including the TOs of customer, products etc. to generate an invoice.


I hope, I could explain it as you can understand.