Brandon, since you are new to Quick Base, I'm not sure if you are meaning the terminology you are using.
I can't stress strongly enough that you must not make your app design with 4 tables to hold the same data tables. It will quadriplicate your work content and make it impossible for you to have meaningful consolidated reports or your over all order status.
No one on his forum will tell you how to move a "row" (ie a record) between tables as its really bad design to design it that way.
Just have a Multiple choice Status field on your record and update the Status as it moves along your internal workflow.
