locked
FOREIGN KEY RRS feed

  • Question

  • User344034269 posted

     The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Ads_Members". The conflict occurred in database "H:\DOCUMENTS AND SETTINGS\ADMIN-PC\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\UPLOAD\APP_DATA\CLASSIFIEDSDB.MDF", table "dbo.Members", column 'Id'. The statement has been terminated.

    Thursday, March 5, 2009 12:56 AM

All replies

  • User-1952482173 posted

    That meant you tried to insert a value into a FK column in the table. That value doesn't exist in the primary key table. For example, in your primary key table, the PK has value 1, 2, 4. But, you tried to insert a value 3 into the FK column in your another table. 3 is not in your PK key column.

     

    Thursday, March 5, 2009 8:59 AM