Database Reference
In-Depth Information
Figure 10-12.
Modifying the KeyColumns property to use a collection
Clicking the ellipsis button launches the Key Columns dialog window (Figure
10-13
); columns can be added
and removed using the right and left arrow buttons. Additionally, columns can be moved up or down by using
the arrow buttons on the left side of the dialog window. Be sure to move the parent column to the top followed by
each level of the hierarchy in its proper order. In our example, the proper order for the Month attribute is the year,
followed by the quarter, followed by the month, as shown in Figure
10-13
.
Figure 10-13.
Selecting multiple KeyColumns
