From the course: FileMaker Pro 12 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Adding charts with related data to layouts

Adding charts with related data to layouts - FileMaker Pro Tutorial

From the course: FileMaker Pro 12 Essential Training

Start my 1-month free trial

Adding charts with related data to layouts

Working with related data in your FileMaker databases provides management and visibility of information in a way that a spreadsheet never could because FileMaker is a relational database not a flat file. Other systems like spreadsheets allow you to chart your data from columns and rows of data, and now FileMaker will also allow you to chart your data in the context of a parent table, yet it will allow you to visualize related data in ways that you couldn't without the backbone of a properly related table structure. For example, let's say that you want to chart order data while looking at a customer record. FileMaker allows you to reach into related tables, and extract data, and we can also use that in charts. In our Exercise File that I have here, you see that I've created a tab on the Customer Detail layout called Order Chart. What I'd like to be able to do is add a chart in here that shows me related order or invoice data. The goal here will be to create a chart that dynamically…

Contents