-
Is there a way to create a composite foreign key that contains 2 columns from different tables? The examples I've seen contain multiple cols but from the same table. Thanks.
-
I don't think such a thing is possible. The foreign key of a child table references the primary key of the parent table. In this case, a single column foreign key of one of the child table will be the same for the other child table, in which case, it does not make sense to have a composite foreign key.
-
thanks Halo - that's what I figured
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|