Overview: In this video I have explained how to set a foreign key relationship between two table of SQL database. This will be very helpful when you want to bring the related table data of current table . SOCIAL : Like TechnoTips official Page : http://facebook.com/technotipstutorial Subscribe : http://youtube.com/user/aapkanigam Follow us on Twitter : @technotipsMVC GET CODE HERE : http://technotipstutorial.blogspot.com/2017/01/part-26-set-foreign-key-relationship.html INTRODUCTION : To set relationship between tables you just need to do following 1. Right click on a column in table design and choose relationship. 2. In relationship popup click on add button ,then select the current relationship and on the right hand side expand the Table and columns specific option .You will get another popup 3.Select the primary table and its column which is matched with current table .Then select the foreign key table column. 4.Finally close the popup and save your table 5.Done RECOMMENDATION: 1.Create Navigation bar (bootstrap playlist) : https://www.youtube.com/watch?v=FwqcoXMwgQU&index=3&list=PLM5JAv_WpgH9BrISrthg3-u6ak8_IlNe5 TAGS : Refersh entity framework Partial view in mvc Set foreing key relationship in sql how to create a - website how to create bootstrap popup modal asp. net mvc asp.net mvc interview questions asp.net mvc 5 tutorial model view controller jquery-ajax Post. Part 26 - Setting foreign key relationship between two table of SQL database Part 26 - Setting foreign key relationship between two table of SQL database