Posted on: 5/8/2013 2:01:38 AM | Views : 286


hi every body
please help me , i need your help
I have two tables named Tafsil & Journals. I have Tafsil_No field name in the Tafsil table. and I have 4 Field in Journal Table  I called Tafsil1, Tafsil2, Tafsil3, Tafsil4 . I want Tafsil_no field from Tafsil Table 4 Field Relation to do it. I encounter the following message
'Tafsil' table saved successfully 'Journal' table - Unable to create relationship 'FK_Journal_Tafsil1'.   The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Journal_Tafsil1". The conflict occurred in database "fintaavoni", table "dbo.Tafsil", column 'Tafsil_No'.
I use SQL SERVER 2012 EXPRESS
...

Go to the complete details ...