Database Reference
In-Depth Information
related to the record you're viewing. Depending on how the relationship is set up, you can
also have a chart that filters its display based on selections you make. And in a multiuser set-
ting, a chart of related data could serve as a real-time monitor to database activity.
Consider the museum attendance database.
Figure 15-28
shows the relationships among the
tables in this system. Charting related records will let you be on a museum's record in the Fa-
cilities table, but graph attendance trends using data from the Attendance table.
Figure 15-28. The Relationships graph for museum attendance tracking shows the associations
among its three tables. Each record in Facility represents one museum. Exhibit contains a record
for each exhibit along with a Facility ID field that links the exhibit back to the facility where it's
located. Attendance records the number of visitors to a particular exhibit on a particular date, us-
ing the Exhibit ID field to maintain an association with the other two tables.
Here's how to create a chart using related records, like the one shown at the end of this
chapter in
Figure 15-30
, using Charts.fmp12 from this topic's Missing CD page at
1.
Switch to the Related Data Line Chart layout by using the Layout pop-up menu
in the Status toolbar and then press Ctrl+L (
⌘
-L) to enter Layout mode
.
2.
In the Status toolbar, select the Chart tool
.
It's the button that looks like a tiny bar chart.
