title: Subform data not updating table
body: <p>I am running MS Access 2010 as a front end to SQL Server Express 2008 R2 using an Access Data Project.</p>
  
  <p>I have two tables: "Individuals" and "Researchers".</p>
  
  <p>The "Individuals" table has primary key "Individual_ID". A foreign key in the "Researchers" table called "Researcher_ID" references "Individual_ID".</p>
  
  <p>I created a form bound to the "Individuals" table and made it a Data Entry form. Then I added a subform control bound to the "Researchers" table, and using the subform wizard specified the one-to-many relationship from Individuals to Researchers.</p>
  
  <p>I can enter data into the main form fine, and it populates the subform's "Researcher_ID" field in the subform with the "Individual_ID" from the main form. The entries are even saved within the subform.</p>
  
  <p>The problem: The subform is not inserting new records into the "Researchers" table with the new records I create in the form and subform...even though it does insert new records into the "Individuals" table.</p>