Delete problem with Transaction Table due to foreign key

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

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

Posted 26-Apr-11 0:33am

mohd vaquas

Add a Solution

Comments

NuttingCDEF 26-Apr-11 6:45am

From what you say, it sounds as though it should work. Are you sure the Transaction table doesn't participate in any other relationships that could be causing the problem? Exactly what error message do you get? How are you doing the delete? SQL Management Studio, Linq to Sql or what? Are you doing this in a SQL transaction and, if so, is there anything else going on in the transaction that could be an issue? Can you dump some SQL CREATE code for your tables / relationships that we could look at?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

LakshmiNarayana Nalluri · Answer 1 · 2011-04-26T01:37:00

Solution 1

If you want delete records with foreignkey relation

1st you can delete in child table records.

Posted 26-Apr-11 1:37am

LakshmiNarayana Nalluri

anvas kuttan · Answer 2 · 2011-04-26T01:49:00

Solution 2

hi,,

Go to relationship window by modifying table
on the bottom there is insert and update specification, in that change delete rule to cascade for each relation. by doing this it will delete the child node too ..

happy coding

Posted 26-Apr-11 1:49am

anvas kuttan