Link a chart as a record in a field

[FL]

What is the best way to link a chart to a field for many records? Or, are
there any templates that are already made up to do this?

Thanks

 

[Duane Hookom]

Chart are displayed on either forms or reports. A chart control has a Row
Source property. This property is used to select the fields/records displayed
in the chart.

 

[Evi]

Could you give us a concrete example of what you want?
It is possible (but only possible!) that you mean that you want a chart to
be linked to a group of records eg a chart showing the sale of groceries
needs to compare how much of each item each individual company is buying. If
yes, need to group by this field using the Sorting Grouping box and put your
chart report into the Group footer as a subreport, linking it using the Link
Master/Child field in the Properties of the subreport.

You may mean that you want the chart to appear under eg every 10 records but
you have no specific way of grouping the records.

Let us know.

Evi

 

[FL]

Evi, sorry for confusion. The chart is created by Excel and has a file name
(filename.xls). For one record I would like to link a chart and when it's
sent to a report in access the chart will appear. For another record a
different chart (another file) will be linked to a new record. This record
can also be displayed on a report. I guess the charts are like linked
photo's on a report. Unless, this can be done by some copy method. Seems
like my table would need a copy of each chart to do this. How can I best
manage this task with consideration for not growing the database at a
significant rate?