title: Adding subrecords in an Access table
body: <p>I'm working on creating an Access database used to keep track of my workout progress.  </p>
  
  <p>For the moment, I have 2 tables:  </p>
  
  <p><strong>Training_Session:</strong></p>
  
  <pre><code>Date  
  Start_Time  
  End_Time  
  Total_Time  
  </code></pre>
  
  <p><strong>Exercise:</strong></p>
  
  <pre><code>Type  
  Weight  
  Repetition  
  </code></pre>
  
  <p>The table exercise would contain the exercise I did for a particular session. I wanted to upload an image I took of the database I'm trying to produce but for some reason I can't use the upload image feature and I need 5 reputation to ask on meta.</p>
  
  <p>Basically, it would look like:</p>
  
  <pre><code>  Date1       | Start1    | End1   | Total1  
  - Exercise1.1 | Weight1.1 | Rep1.1  
  - Exercise1.2 | Weight1.2 | Rep1.2  
  - ...  
    Date2       | Start2    | End2   | Total2   
  - Exercise2.1 | Weight2.1 | Rep2.1  
  - Exercise2.2 | Weight2.2 | Rep2.2  
  - ...  
  ...
  </code></pre>
  
  <p>Like with a subdatasheet. The only thing is that the tables are unrelated, there's no field that could be used to link them together.</p>
  
  <p>Is it possible to insert a "different" table exercise into each record of the table training_session?</p>