I've created a pie chart that displays values from a query/view called WasteMgmtMethodPcts in my Access database. The query/view consists of three columns:
[MgmtPlanID] which is the key column,
[Percentage of total mass] which is the Data Series, and
[Waste management method] which is the Label field.
What I want to do is to display a pie chart for each individual MgmtPlanID, which shows Percentage of total mass as divided between Waste management methods for the specific MgmtPlanID. I've defined a master-detail relationship for the "Table" WasteMgmtMethodPcts to the table WasteMgmtPlans. I then created a link to the pie chart that looks like this (for example): Waste_management_totals_chart.asp?mastertable=WasteMgmtPlans&masterkey1=7
This does not help as the chart displays data for all MgmtPlanID. Is there a way of defining master-detail relationships for a chart?