Please help!!! I have 2 tables “Orders & Products”. In orders table, It has column “Customer name & Product Code 1” while products table has column “Customer name & Product ID (data is as same as product code 1”) & Price". I want to look up price fro...

Hi All, I would like to copy history order with new order ID; however, I just copy only order data but cannot copy order detail together like below pictures. Is it possible to copy both order and order detail together with new order ID? How can I do ...