Good Evening,
I have problem to delete record from transaction table.
i have two table which are given below.
1.ItemMaster(itemId(pk),ItemDescription,Remarks)
2.Transaction(TransactionId(pk),transactiontype,Itemid(FK),TransactionDate,Remarks)
both table have record,when i try to delete ItemMaster Record which is assign to transaction record then its give me the foreign key conflict thats right.but if i try to delete a transaction table record then also give same foreign key conflict.
so please give me solution to how i delete transaction record.
thanks