TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
try abc
1.1k
306
488.7k
Referencing Primary key twice in one table
Jan 30 2008 12:09 AM
Referencing Primary key twice in one table
Is it possible to create 2 foreign keys from the same primary key, both of them in the same table?
This is a simplified version of the tables I want to create:
Supplier Table
-supplier_id(primary key)
-supplier_name
Asset table
-Asset_id
-Supplier_id(foreign key 1)
-ServicedBy_Supplier_id(foreign key 2)
If this is possible how can I make them refer back to the same primary key?
It does not support Cascade delete and update in both the foreign keys ?
What is the solution for this ?
Reply
Answers (
2
)
BinaryReader Object issues
Creating Click Event Of Link Label