Database Reference
In-Depth Information
6. Add a relationship between the
Product
and
Product Category
tables
by dragging the
ProductSubcategoryKey
column in the
Product
table to
the
ProductSubcategoryKey
column in the
Product Category
table.
7. Add a relationship between the
Product Category
table and the hidden
_ProductCategory
table by dragging the
ProductCategoryKey
column
in the
Product Category
table to the
ProductCategoryKey
column in
the
_ProductCategory
table.
8. Right-click on the
Product Category
table and hide the two key columns.
9. To return to the grid view and work with a single table, you can right-click on
the header of the
Product Category
table and click on
Go To
.
Search WWH ::
Custom Search