How is a relationship created in SQL Server?

Answer 1

In the table design view, right click the column name of the entity you want to create a relationship with and then select "Relationships" which opens the Properties window with the Relationships tab selected. Click on "New" and then verify the "Primary key table" and "Foreign key table". Select the primary key from the grid below the "Primary key table" name (left side of grid) and then select the column name you right-clicked on earlier from the grid below the " Foreign key table" name (right side of grid). Selecting each one in turn sets the two into the desired relationship.