Home » Developer & Programmer » Forms » foreign key problem
foreign key problem [message #78773] Sun, 17 March 2002 22:45 Go to next message
Angela
Messages: 13
Registered: October 2000
Junior Member
I want to have a foreign key from different tables. Is it possible? For example: name. It refer to "friends_names" in table friend, and it also may refer to different table, i.e., table family "family_name". So, if it is possible, how to do that?
Thank you, and please reply as soon as possible.
Re: foreign key problem [message #78778 is a reply to message #78773] Mon, 18 March 2002 00:50 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
yes, it is possible

1. create primary key on "name" in first table
2. create foreign key(s) on "friends_names"/"family_name" etc
Previous Topic: How Can I use the function in report.
Next Topic: Insert records into database from form
Goto Forum:
  


Current Time: Thu Mar 28 04:13:03 CDT 2024