General information
Forum:
Microsoft SQL Server
I have two tables called Menus and Menus_Item.
I have allways join both tables by using PK from menus and storinging it in a FK field on the Menus_item.
But I was looking at somebody else database desing and he was using a link table to join both tables.
The link table name is Menus_Menus_item_link.
This table has a field for storing the PK of the Menus table and a field for storing PK of Menus_Item table.
Question : Is this a better database desing ?. What are the benefits of having a link table?
I have never used link tables and I am a little bit confused.
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only