search for: nextsteprequest

...hat 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 either allowing, or disallowing me from making the request. The question is this: is this the best way to do it (theorizing t...