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!
+25Have 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).
Kamille_Parks11 wrote:
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).
Thank you! That helps a lot.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.