OraFAQ Forum: Forms » How to relate 2 fields of a same table

Home » Developer & Programmer » Forms » How to relate 2 fields of a same table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to relate 2 fields of a same table [message #86254]

Wed, 15 September 2004 03:12

Pandiyan of iGATE
Messages: 1
Registered: September 2004

Junior Member

I have a table called Employee with the following fields

Name :

Empid:�� ----[>]not null

Managerid:��----[>]can have null and should refer to empid.

dept:��

now i want to make managerid to refer to empid of the same field. is it possible to add constraint while creation?. i dont want to write any trigger for validation.

Plz help me out........

�

�

Report message to a moderator

Re: How to relate 2 fields of a same table [message #86255 is a reply to message #86254]

Wed, 15 September 2004 05:54

raviranjan
Messages: 41
Registered: April 2004

Member

plz clearly write what do u want

Report message to a moderator

Re: How to relate 2 fields of a same table [message #86261 is a reply to message #86254]

Wed, 15 September 2004 19:41

iGATE Pandiyan
Messages: 5
Registered: September 2004

Junior Member

Thanks for your reply..........
anyhow i got the solution....

Report message to a moderator

Re: How to relate 2 fields of a same table [message #86316 is a reply to message #86255]

Tue, 21 September 2004 01:51

Suvransu
Messages: 1
Registered: September 2004

Junior Member

Frm what I understand ur problem use foriegn key (that will help you link managerid to employee id)

Report message to a moderator

Previous Topic:	LOV / RG
Next Topic:	Please help. Its urgent.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 17:14:19 CDT 2024