Composite Key relationship

[jaryszek]

Hi Guys,

i have 2 tables and want to relate them.

tblOsServers is coming from Excel.

Generally i do not have primary key but i created composite key in tblOperatingSystems on fields: Publisher, Sku, Offer as unique.

And now i have table tblOsServers.
Generally one OperatingSystem can have many ServersID.

And now i have to relate this tables somehow. And in this field i need your help. How can i achieve this?

Please help,
Jacek

 

[Minty]

I think you need a third junction table - tblServer_OpSystems

BUT - I'm confused by the Server ID in tblOsServers is that not unique?

In fact, I'm generally confused by the naming of the tables and fields, and the lack of a single PK in the OS table.
An OS is an OS. If you are storing a price point/order of it that belongs in another table.

You would then save that and your server OS junction would simply refer back to the offer table?

 

[theDBguy]

Hi. When you say tblOsServers is coming from Excel, are you saying it's a linked table?

 

[jdraw]

Jacek,

Please provide a little more description to help readers understand your post/requirement.
In most scenarios you have a business issue/problem/opportunity that you can describe in "business terms". And from that description you can design tables and relationships that you can test and adjust with sample data.
Your comment Generally i do not have primary key... is a little suspect, but maybe a broader description would clarify.
Good luck.

 

[jaryszek]

Hi Guys,

sorry for my late answer.
Wow i am grateful for providing such a nice solution.

And explanation. I will implement this now and try...
Let know you if is working for me.

Best,
Jacek