title: Insert record into table if entry does not exist in another table- with an extra twist
body: <p>Hi to all you mighty SQLsuperheros out there..
  Can anyone rescue me from imminent disaster and ruin?</p>
  
  <p>I'm working with Microsoft Access SQL. I'd like to select records in one table (table1) that don't appear in another (table2) .. and then insert new records into table2 that are based on records in table1, as follows:</p>
  
  <p>[table1]
  file_index   :  filename </p>
  
  <p>[table2]
  file_index   : celeb_name</p>
  
  <p>I want to: </p>
  
  <p>Select all records from table1 where [filename] is like <em>aud</em>
  and whose corresponding [file_index] value does not
  exist in table2 with with field [celeb_name] = 'Audrey Hepburn'</p>
  
  <p>With that selection I then want to insert a new record into [table2]</p>
  
  <p>[file_index] = [table1].[file_index]
  [celeb_name] = 'Audrey Hepburn'</p>
  
  <p>There is a one to many relationship between [file_index] in [table1] and [table2]
  One record in [table1], to many in [table2].</p>
  
  <p>Many thanks</p>