Creating foreign key in SQL Server Management Studio

Using SQL Server 2008 R2 I am trying to establish a relationship between two companies. For the sake of illustration; one table is called 'company', another is called 'branch'. Company and branch both have primary keys. Company should relate to Branch in a one to many relationship. A row called 'branches' should be the foreign key in the table Company; linked to the primary key of the Branch table.

Naturally I go for the 'relationships' option in the Table designer menu in SSMS. But this is as far as I get.

The Tables and Columns Specification Table entries looks editable - but apparently isn't.

This is very confusing o.O Anybody know how to... edit it?

Answers


Click on the ... at the right of the "Tables and Columns Specification"


Need Your Help

fs: how do I locate a parent folder?

javascript node.js filesystems

How do I write this to go back up the parent 2 levels to find a file?

How to run dynamic web projects of Eclipse in Chrome?

eclipse google-chrome web eclipse-plugin

Before I deleted my previous version of Eclipse Kepler, when I hit Ctrl+F11 in Eclipse, while using Dynamic Web Projects, Chrome opened a tab of the project .