I have a two tables. On table has a unique order number and the associated time it entered a production stage (status). I have another table which has the unique order number and time stamp for each time a production stage changed (status).
On the first table how can I systematically determine the next time a production stage (status) changed after it entered the stage?
i.e. if order 1234 went into stage 5 on 7/1/2015 and left of 7/6/2015. How can I populate this on my first table?
Products may enter stages mul.