title: The INSERT statement conflicted with the FOREIGN KEY constraint
body: <blockquote>
  <p>Error: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint &quot;FK__Item__order__3AE27131&quot;. The conflict occurred in database &quot;pmall&quot;, table &quot;dbo.ItemSaved&quot;, column 'id'.</p>
  </blockquote>
  <p>Here's my table:</p>
  <h3>ItemSavedUnits</h3>
  <ul>
  <li>id</li>
  <li>ItemID (is set in this table a FK to Item.id)</li>
  <li>...etc.</li>
  </ul>
  <p>Here's my insert statement:</p>
  <pre><code>insert into ItemSavedUnits (ItemID, name, Price)
  select ItemID, name,Price
  from ItemUnits where ItemID = 92439 
  </code></pre>
  <p>I don't really understand why if I a FK constraint on ItemSavedUnits.ItemID that is related to Item.ItemID and ItemUnits has no constraints at all why I'm getting a problem inserting into ItemSavedUnits. The ItemID I'm tryign to insert does exist in the Item table.</p>