Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Moshodiruth
Starting Member
1 Post |
 Posted - 2012-08-08 : 06:19:51
|
| How do i reference a [PK][FK] of an associative in another associative of that associative.E.g I have a table (Client_Order)with PK - 'Order_ID', An associative (Order_Line) which references the PK 'Order_ID' and makes it a [PK][FK]. Now the problem is that i have another associative of the Order_Line associative called (Product_Order) which also has the [PK][FK] of 'Order_Id'. Question is, in the script, what do i reference the 'Order_ID' in the Product_Order table as?? do i reference it from (Order_Line) or (Client_Order) |
|
|
|
|
|
An associative of an associative