Adding foreign key in visual studio 2012

Question

I'm developing my first MVC project in Visual Studio 2012. Because i prefer "database first" approach i've started to design database. The question is: Why when i want to add foreign key i have all key properties disabled to edit (left):

I can only modify script directly (right) but is this really only solution? Or i did something wrong?

Thanks for any help.

Answer 1

All you need to to do is right click on the foreign key options on the right side of the table view and select add new foreign key. Then in T-SQL window you need to manually edit the the foreign key and foreign key table.