title: Edit a query with left join tables
body: <p>I'm having some trouble in Access 2002...</p>
  
  <p>I have two tables, one containing around 60k occurrences and one with a column and the foreign keys to make the join. In my form, I set the source to a query with these two tables joined (left join on the empty one). Basically, I end up with my  60k occurrences and my new column at the end.</p>
  
  <p>Now, I need to allow my users to edit this field in my form. I found out that when the corresponding data exists in my empty table, I can edit the field just fine, however since we need this empty table to contain only the occurrences where we need to add the new column, I can't simply make a new entry for all of my occurrences.</p>
  
  <p>Here are a schema of the two tables:</p>
  
  <p>Table 1:</p>
  
  <pre><code>ID    Sequence    Col1    Col2    Col3    Col5
  60k
  </code></pre>
  
  <p>Table 2:</p>
  
  <pre><code>ID    Sequence    Col6
  0
  </code></pre>
  
  <p>And my query:</p>
  
  <pre><code>SELECT tblOne.*, tblTwo.Col6
  FROM tblOne 
  LEFT JOIN tblTwo ON (tblOne.Sequence=tblTwo.Sequence) AND (tblOne.ID=tblTwo.ID); 
  </code></pre>