Export entries to another table

[Laura_Deike]

My table consists of customer orders. Once the order has been completed, I would like to move the entry to out of my working table to another that is only completed orders. How can I set up the table to do this?

Thanks for your help!

[Kamille_Parks]

Have you considered doing this with Views? You could use one table, and have three views set up using filters: All Orders, Completed Orders, and Orders In-Progress.

Generally, we don’t recommend using two tables to house the same type of data (in this case: orders).

[Laura_Deike]

Thank you! That helps a lot.