title: Subtables in MS Access
body: <p>I am working on a database that has one main table with the entry rows having an individual table for calculations.</p>
  <p>So I have about 9 tables that have calculations /values in that are associated with an individual indicator field entry in my main table. I would like to link the calculation tables to the individual entry.</p>
  <p>The subdatasheet allows me to do this. However, it populates all the entries with the same table which I do not want as one calculation table is only associated to one entry.</p>
  <p>I can’t create one table for all calculations as they have different types of data and are calculated differently so I can’t link with regards to relationships.</p>
  <p>The only solution I can think of is by populating a new field called “results calculations” and populate it with the title of the calculation table associated to the individual entry.</p>
  <p>Is there another way I would love all the data to be as accessible in one table as simplified as possible.
  (I am new to MS Access so any advice will be appreciated.)</p>
  <p><a href="https://i.stack.imgur.com/Yhlls.png" rel="nofollow noreferrer">The result of using subdatasheet</a></p>
  <p><a href="https://i.stack.imgur.com/ScFOM.png" rel="nofollow noreferrer">What I need to link to each indicator</a></p>