Can a Compound key be set as a primary key to another table?
- by Nikos
Can a compound key be set as a primary key to another table?
For instance i have the tables:
Books -with Primary Key:Product_ID
Client -with Primary key: Client_ID
Clients_Books -with Compound Primary Key:Product_Id and Client_ID
I want to set this compound Primary key from Clients_Books as a Primary Key to another table named: Order_Details. But I don't want to use the Product_ID and the Client_ID from the Books, Clients tables.
Does this make sense? All opinions more than welcome.