So, I have three tables. 1. cart items
2. cart - which contains refrence of cart items
3. orders - which contains ref of cart
Now suppose a person has placed an order and now i want to add the current cart into orders table, as well as delete his current cart hence the cart items. but in doing so in the workflow, when i delete the current cart after adding it in orders table, it gets deleted from orders table also. because obviously it is being refrenced from cart table.
so is there any way by which i can add the cart into orders table and then delete that cart without affecting its copy in the orders table