title: INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server
body: <p>I am getting the following error. Could you please help me?</p>
  
  <blockquote>
    <p>Msg 547, Level 16, State 0, Line 1<br>
    The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Sup_Item_Sup_Item_Cat". The conflict occurred in database "dev_bo", table "dbo.Sup_Item_Cat". The statement has been terminated.</p>
  </blockquote>
  
  <p><strong>Code:</strong></p>
  
  <pre><code>insert into sup_item (supplier_id, sup_item_id, name, sup_item_cat_id, 
                        status_code, last_modified_user_id, last_modified_timestamp, client_id)   
  values (10162425, 10, 'jaiso', '123123',
          'a', '12', '2010-12-12', '1062425')
  </code></pre>
  
  <p>The last column <code>client_id</code> is causing the error. I tried to put the value which already exists in the <code>dbo.Sup_Item_Cat</code> into the column, corresponding to the sup_item.. but no joy :-(</p>