Linking a chart in a report

[martinainscough]

Hi All

I am wondering how you link a field in a chart that is on a report with a sparate field that is on the report. I am trying to show a chart that displays products sales but i want it to be the same product as the other information on the form. Therefore i need to link product code on the chart to product code on the report.

If you could help me it would be much appreciated

Thanks

Martin

 

[geraldcor]

I have never worked with charts but I beleive using a subreport is your answer here. Have your chart in the subform and just have the link master and slave fields be the product code. Then when you open the record on your main report the subreport matches. Vague answer but maybe it can get you started.