Home » Developer & Programmer » Forms » foreign key - continued
foreign key - continued [message #78788] Mon, 18 March 2002 04:05 Go to next message
Messages: 13
Registered: October 2000
Junior Member
Thank you for the reply for my previous question about the foreign key from different tables. Actually, what I'm trying to ask is: For example: table list has column name (which is not a primary key). I want to set it as foreign key references from "friends_names" in table friend, and also references "family_name" in table family. So, maybe in the previous question I was wrong to interpret it. Thank you and please reply as soon as possible.
Re: foreign key - continued [message #78789 is a reply to message #78788] Mon, 18 March 2002 04:19 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
no u can not create a foreign key unless u Add the unique or primary key to the first table.better u create primary key for name.

otherwise u will end up with error

ORA-02270: no matching unique or primary key for this column-list
Previous Topic: Insert records into database from form
Next Topic: button_palette
Goto Forum:

Current Time: Mon Feb 06 09:10:03 CST 2023