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 i...
Forum Discussion
Personally, I would set up a log table and log each change in status for each order. This would give you a set of data you could use to answer many questions about your processes over time.
Just curious, why a separate table for statuses? Why not just a status field on the orders table? Or can other tables have statuses as well?
~Rob
Just curious, why a separate table for statuses? Why not just a status field on the orders table? Or can other tables have statuses as well?
~Rob
