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.
Blocked AccountPosted Dec 11, 2012, 8:06 AM
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 ArurPosted Dec 11, 2012, 8:03 AM
http://sqlwithmanoj.wordpress.com/2010/12/21/update-statement-conflicted-with-the-reference-constraint/