I'm trying to build a checklist/signoff system. Basically, I've got a form that the user fills out, see below. The user is automatically put there based on who is logged in.
http://i.imgur.com/sTysmyV.jpg
Each Checklist is attached to a specific Job number. So say a manager wants to look at Job 1000, he'll click it, navigate to "Checklists" and he'll see the checklist below.
http://i.imgur.com/kGqcyZt.jpg
Now, I have an option to select different revisions of a checklist for a job so that managers can look at different revisions.
I'm just not sure on how to string everything together.
I have 2 tables so far.
checklist_component_stock
and checklist_revision
I'm not sure how to link everything correctly in the tables so when Rev1 gets pulled up say for Job 1000, it shows the correct rows that have been created for that specific job and revision.