How to link a table (2PK, 2PK)?

Sql Server. Sql Server Management Studio.


How to connect (if at all possible) these tables on the same key ? The two tables have two primary key. And in the end can not in any way be linked without adding another key (Date), but I have no Date field.
March 20th 20 at 11:38
2 answers
March 20th 20 at 11:40
probably because the two primary keys in one table that do not exist? but there is one group, and selected incorrectly because of misunderstanding what is unique key?

if "product" in terms of business logic can not exist without "order", it needs to be a FK from the field on NumberOrder Number.
Sorry for nubstvo. That is, I need to create one primary key, and then the other as the index. 5ccc4d81ad1fd071456424.png - coleman_Mills73 commented on March 20th 20 at 11:43
March 20th 20 at 11:42
Foreign key:5ccc6e94b0b1e969460806.png

Find more questions by tags C#SQL Server