I am getting this error when I am trying to make foreign key relationship?

Question

I am getting this error when I am trying to make foreign key relationship :

As soon as I click on save, this error occurs :-

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_tb_stadmdet_tb_prgdet". The conflict occurred in database "admission", table "dbo.tb_prgdet", column 'prgcod'.

Can anybody help me out with this problem, THANKS

Answer 1

You tried to alter the table with out dropping the key FK_tb_stadmdet_tb_prgdet..Drop this key and add again.