I am insert one table ERP_GatePass but ERP_GatePass_old table will be Refer,So mthis Error Occur

Question

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ERP_AssetIssue_ERP_GatePass". The conflict occurred in database "ERP_ASSETS_NFA", table "dbo.ERP_GatePass_Old", column 'GPID'. The statement has been terminated.

Possible duplicate of [INSERT statement conflicted with the FOREIGN KEY constraint](http://stackoverflow.com/questions/2965837/insert-statement-conflicted-with-the-foreign-key-constraint) — Suprabhat Biswal, Oct 01 '15 at 06:18

score 0 · Answer 1 · edited May 23 '17 at 12:34

0

In your table dbo.ERP_GatePass, it has a foreign key reference to another table. The FK works is it cannot have a value in that column that is not also in the primary key column of the referenced table.

You can Rectify or findout using this following way Source

edited May 23 '17 at 12:34

Community

1
1

answered Oct 01 '15 at 06:24

Krsna Kishore

8,233
4
32
48

@Ananda Somewhere you are sending a value as `0` that has foreign key relation with the primary key column – Krsna Kishore Oct 01 '15 at 06:25

I am insert one table ERP_GatePass but ERP_GatePass_old table will be Refer,So mthis Error Occur

1 Answers1