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....