title: How to link these database tables together when inserting
body: <p>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. </p>
  
  <p><a href="https://i.imgur.com/sTysmyV.jpg" rel="nofollow noreferrer">http://i.imgur.com/sTysmyV.jpg</a></p>
  
  <p>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.</p>
  
  <p><a href="https://i.imgur.com/kGqcyZt.jpg" rel="nofollow noreferrer">http://i.imgur.com/kGqcyZt.jpg</a></p>
  
  <p>Now, I have an option to select different revisions of a checklist for a job so that managers can look at different revisions.</p>
  
  <p>I'm just not sure on how to string everything together. </p>
  
  <p>I have 2 tables so far.</p>
  
  <p>checklist_component_stock</p>
  
  <p><img src="https://i.imgur.com/xB9HJL8.jpg" alt="Imgur"></p>
  
  <p>and checklist_revision</p>
  
  <p><img src="https://i.imgur.com/TcmBQCp.jpg" alt="Imgur"></p>
  
  <p>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.</p>