JoshPrimm1
7 years agoQrew Member
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!