title: sqlite - Multiple records referenced to single row
body: <p>I created a &quot;tasks&quot; program (python3.6) which has the following sqlite DB structure:</p>
  <pre><code>date, time, project, task, owner, comment
  </code></pre>
  <p>Each row represents a task and its working fine.  Now I want users to press the &quot;add&quot; button, a new comment field appears, filled out and saved. The new comment should be &quot;tagged?&quot; to the row of the original task so it can be shown to the user later.</p>
  <p>The user should be able to add as many comment fields as they want over the course of the task.</p>
  <p>It would end up looking something like this:</p>
  <pre><code>[row1] date, time, project, task, owner, comment, comment, comment, comment, comment
  [row2] date, time, project, task, owner, comment, comment, comment 
  </code></pre>
  <p>What is the best way to set the tables up within Sqlite? How do I link these extra comments to the same row when I dont know what the max number of comments will be?  Not even sure what to search on this.</p>
  <p>TIA</p>