title: How do I make a subtable in Access in this situation?
body: <p>I'm aware that someone will see this and say "I'm sure there's already an answer to "how do I make a subtable", so this question is repetitive." Well, no answers seem to be relevant to THIS situation. Here goes:
  I own a car business. I want to make a rolling list of costs associated with each car, to eventually be summed into "totalCosts". </p>
  
  <p>I have table  </p>
  
  <pre><code>ASSETS
       stock#, 
       make, 
       model, 
       purchase price, 
       totalCosts
  </code></pre>
  
  <p>and table  </p>
  
  <pre><code>COSTS
       description, 
       cost (in $)
  </code></pre>
  
  <p>so I want the COSTS table to contain several costs like:</p>
  
  <pre><code>purchase price $2,000
  paint $50
  new tires $200 
  </code></pre>
  
  <p>I can figure out how to sum the costs, but mainly I need to know how do I make the COSTS table to exist for each car or stock#. So each stock# would have its list of COSTS, which I would sum and insert into total costs. </p>
  
  <p>The only solution I see now is to make a costs table that contains every cost with a stock # on the same line, but I would like to have a separate costs table for each stock #</p>