Question
Count number of times that a job starts over
I have a parent table "Orders" and child table "Statuses". My orders move through a production line and as they move along a new status is added with a value field that indicates where that order is in the line. Many times something happens and the order has to be started over (value field in status goes from 5 to 1, for example). How can I count the number of times each order has to be started over? I know I could probably do this with a QB action by holding the "most recent value" of an order status and updating if new most recent value is less than the last, but I'd like to be able to apply it to every order already entered, not just from here going forward. Hope this makes sense. Thanks in advance for the help!
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.