title: inserting into a view in SQL server
body: <p>I have a SQL Server as backend and use ms access as frontend.</p>
  
  <p>I have two tables (<code>persons</code> and <code>managers</code>), <code>manager</code> is derived from <code>persons</code> (a 1:1 relation), thus i created a view <code>managersFull</code> which is basically a:</p>
  
  <pre><code>    SELECT *
        FROM `managers` `m`
  INNER JOIN `persons` `p`
          ON `m`.`id` = `p`.`id`
  </code></pre>
  
  <p><code>id</code> in <code>persons</code> is autoincrementing and the primary key, <code>id</code> in <code>managers</code> is the primary key and a foreign key, referencing <code>persons</code>.<code>id</code></p>
  
  <p>now i want to be able to insert a new dataset with a form in ms access, but i can’t get it to  work. no error message, no status line, nothing. the new rows aren’t inserted, and i have to press escape to cancel my changes to get back to design view in ms access.</p>
  
  <p>i’m talking about a <code>managers</code> form and i want to be able to enter manager AND person information at the same time in a single form</p>
  
  <p>my question is now: is it possible what i want to do here? if not, is there a “simple” workaround using after insert triggers or some lines of vba code?</p>
  
  <p>thanks in advance</p>