Database Reference
In-Depth Information
3.
Below the fields on the layout, drag out a box about as tall as the available space
in the Body part, and roughly as wide
.
The Chart Setup dialog box appears.
4.
Under Data Source in the right column, change the Chart Data value to Related
Records
.
A new Related Table pop-up menu appears.
5.
From the Related Table pop-up menu, choose Attendance
.
6.
Below “Sort Order of Related Records,” click the Specify button and then
double-click Visit Date field on the left to place it in the sort order. Click OK.
7.
Set “Chart display when sorted” to the Individual record data option
.
The Data Source settings should now match
Figure 15-29
.
Figure 15-29. Choosing Related Records for your data source isn't enough. You also have
to specify which related table's records you want charted.
8.
Click the Chart heading and set Chart Type to Line. Click the square button to
the right of the Chart Title field and then select Specify Field Name
.
The Specify Field dialog box appears.
9.
Set the pop-up menu to Facility. Click Facility Name field and then click OK.
