|
SBRDude
Starting Member
2 Posts |
 Posted - 08/30/2012 : 10:53:38
|
Seems like this is a basic thing and that I already understand it, but wanted to make sure.
A quick description of a situation.
An orders table with an orderID column that is the PK
A products table with a productID PK.
An ordersdetail table with FKs to both orders.orderID and products.productID.
Is this the right way to set up the ordersdetail table, with a FK to the order table and the product table?
-Milo
|
|
FKs in one table to multiple tables
