nitha jen (4/1/2013)

---

hello sir..can u plz help me .....i don't knw how to solve this conflict ''The INSERT statement conflicted with the FOREIGN KEY constraint "FK_product_details". The conflict occurred in database "catalog", table "dbo.product_details", column 'product_id' ".......

i have 2 tables, product_details and purchase_details.....

CREATE TABLE product_details

(

product_id int identity(1,1) not null,

product_name varchar(500),

product_catagory varchar(100),

CONSTRAINT PK_product_details PRIMARY KEY(product_id)

)

CREATE TABLE purchase_details

(

Purchase_id int not null identity(1,1) ,

product_id int CONSTRAINT FK_product_details FOREIGN KEY REFERENCES product_details(product_id) ,

Product_Name varchar(500),

Product_Cost VARCHAR(500),

Product_Quantity varchar(500),

CONSTRAINT PK_Purchase_details PRIMARY KEY(Purchase_id)

)

when i was try to insert values in 'purchase_details' that error msg displayed.......i dont know wats the mistak there....