Hi Friends I am facing Sql insert problem

Question

Hi Friends I am facing This problem can any one help me

The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_ECTemplate_AG_Purchase_Packages". The conflict occurred in database "iAgentSolutionsTest1", table "dbo.AG_Purchase_Packages", column 'PurchasePackageID'.

The statement has been terminated.

Manish Dwivedi · Answer

Hi That error means that the table you are inserting data into has a foreign key relationship with another table. Before data can be inserted the value in the foreign key must field must exist in the other table first.

Shivanand Arur · Answer

Check out this link... http://sqlwithmanoj.wordpress.com/2010/12/21/update-statement-conflicted-with-the-reference-constraint/