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.
Printable View
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