Kingston Dhasian (4/26/2013)
In your table GV_Voucher, the column TransactionID has not been defined as a UNIQUE KEYYou will have to make TransactionID a UNIQUE KEY in GV_Voucher to create this FOREIGN KEY constraint
But, as I mentioned in your other thread, if the column TransactionID is indeed unique, then you need not add the column in your GV_ReceivedOffice table at all.
http://www.sqlservercentral.com/Forums/Topic1446803-391-1.aspx
TransactionID is not unique..
But as VoucherNo is unique so I created a unique constraint combining these two columns (VoucherNO, TransactionID)
but still am getting that error 🙁
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/