search for: ordernum

..., I have to request that the assigned person perform each of the steps, and need to make sure that I cannot request that the next step be done unless the previous one has been completed. What I have thought is to have a projects table and another table named project_steps with fields: id, name, ordernum, project_id. The ordernum tells the order in which the steps must be performed. Then, create another table, nextsteprequest, with fields: id, project_id, project_step_id. I was thinking that when I request the next step be done I would have the app check to see if the numbers matched up, thus...