SQL danna kattiya help me please

[WAMI7]

me error message eka-

Major Error 0x80004005, Minor Error 28599
> alter table Facilities add constraint C_Number_fk
foreign key (C_Number) references Facilities (C_Number)
The referenced table must have a primary or candidate key. [ FK Name C_Number_fk ]

 

[WAMI7]

bumpi

 

[WAMI7]

bumpit

 

[WAMI7]

bumppitle

 

[samaradivakara]

reference table ekata key ekak danna

 

[WAMI7]

reference table ekata key ekak danna

an egsample please

 

[WAMI7]

reference table ekata key ekak danna

An Example please

 

[samaradivakara]

uba ekama table eka neda refer karanne

 

[sanmahesh]

mona wage presses ekak karanna kotada me error eka awe..teble joint ekakda..? ahema nam primary key vidiyata ekka denna onna..

 

[Tom Riddle]

me error message eka-

Major Error 0x80004005, Minor Error 28599
> alter table Facilities add constraint C_Number_fk
foreign key (C_Number) references Facilities (C_Number)
The referenced table must have a primary or candidate key. [ FK Name C_Number_fk ]

Facilities eke indan Facilities table ekama reference karanne mokada??

 

[WAMI7]

uba ekama table eka neda refer karanne

ow??ithin mokada??

 

[WAMI7]

Facilities eke indan Facilities table ekama reference karanne mokada??

ammata sir ekane

 

[kosandpol]

foreign keys පාවිච්චි කරනවා නං එවා තියෙන order එක බලපානවා. හරි Order එකට refer කරන්න ඕනෙ.
මේක කියවලා බලන්න :
http://social.msdn.microsoft.com/Forums/en/sqlce/thread/5a71948b-dfb1-46a5-8688-ccab9317e959

 

[WAMI7]

bump

reference table ekata key ekak danna

uba ekama table eka neda refer karanne

mona wage presses ekak karanna kotada me error eka awe..teble joint ekakda..? ahema nam primary key vidiyata ekka denna onna..

Facilities eke indan Facilities table ekama reference karanne mokada??

i am new to SQL. any way thank you very much my friends for helping.

 

[samaradivakara]

ow??ithin mokada??

ane manda ban... dan owa mathakath na