title: MS Access SQL Insert data into table with relationship
body: <p>I have been searching everywhere for a solution to this problem and I have concluded that I may be asking the wrong question. I am hoping that someone here can answer this question or tell me the right question to ask. </p>
  
  <p>I have two tables Estimates and TakeoffSheet:</p>
  
  <pre><code>    +----------------------+  +----------------------+
      |   Estimates          |  |  TakeoffSheet        |
      +----------------------+  +----------------------+
      | 1. Estimate_ID = PK  |  | 1. Sheet_ID = PK     |
      | 2. Number            |  | 2. Estimate_ID = FK  |
      | 3. Estimate_Name     |  | 3. Sheet_Name        |
      +----------------------+  +----------------------+
  </code></pre>
  
  <p>I am trying to insert a new row in Takeoffsheet where Estimate.Number=Something. Essentially there is a relationship defined between TakeoffSheet and Estimates however I dont know how to insert a new row in Takeoffsheet, with an Estimate_ID from Estimates. At least not in one SQL statement. </p>
  
  <p>I know I can do it in multiple steps (first get the Estimate_ID, then add a new sheet with that) but I would rather do it in a single statement if possible. Is there a "join" type of insert in MS Access?</p>
  
  <p>Thanks for any help! </p>