SQL primary KEY and foreign key

After the two tables have been built, build the association

1. Right-click the table you want to associate, select design

2. Select the column name you want to associate, right-click, select Relationship

3, the following dialog box appears, click on the bottom left of the Add key, select the right table and column to return the anti-strike ellipsis selection

4, in the bottom dialog box, the primary key table selects the Bumen table that sets the primary key, and below selects the first set primary key, that is the department number Bcode,

Foreign key table, select the Ren table, you need to set the associated foreign key is bumen, will be in the Ren table bumen that column and Bumen table of the primary key Bcode Association.

Query two tables as follows:

SQL primary KEY and foreign key