Establishing the Relationship Between the Master Chart, Parameter, and Detail Chart BACK | 1 2 3 4 5 6 7 8 | NEXT | MAIN
The final step is to establish the relationship among the master chart, the parameter, and the detail chart.

  1. Open the Property sheet by double clicking on the set of pie slices. These are the chart elements that will initiate the drill-down.
  2. Specify the parameter to set. This is the parameter used in the detail query's SQL SELECT statement.
  3. Specify the column on which the master-detail relationship is based.
  4. Specify the name of the query on which the detail chart is based.