The INSERT statement conflicted with the FOREIGN KEY constraint

sql-server, sql-server-2008, t-sql

Solution

Are you absolutely sure that ItemId 92439 exists in the Item table, and not just in ItemUnits?

or

Is your select statement returning null?

Problem

Error: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK__Item__order__3AE27131". The conflict occurred in database "pmall", table "dbo.ItemSaved", column 'id'. Here's my table: ItemSavedUnits - id - ItemID (is set in this table a FK to Item.id) - ...etc. Here's my insert statement: ``` insert into ItemSavedUnits (ItemID, name, Price) select ItemID, name,Price from ItemUnits where ItemID = 92439 ``` 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.

Original source