Part 26 - Set foreign key relationship between two tables of SQL database
To set relationship between tables you just need to do following
o Right click on a column in table design and choose relationship.
o 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
o Select the primary table and its column which is matched with current table .Then select the foreign key table column.
o Finally close the popup and save your table
o Done
0 Response to "Part 26 - Set foreign key relationship between two tables of SQL database "
Post a Comment