When you work with tables in the relationships graph, you are using them to organize your view into your data. The relationships graph shows all the tables in the current file. The file contains the tables, but not the relational structure. Display a related record in a file Define a relationship to another table 1. Each company has many employees (customers of Favorite Bakery). 1 the Companies table containing records for companies where these customers are employed. In this lesson, you will: 1 see how relational databases work 1 define a relationship 1 display data from one related record 1 display a list of related records The sample file in this lesson uses two tables: 1 the Customers table containing records for individual Favorite Bakery customers. You can enter data once, then view and use that data in related tables or files. Lesson 11 Making databases relational Relational databases let you easily view related data and streamline data entry. For more information about charting data, see chapter 3 of the FileMaker Pro User’s Guide and FileMaker Pro Help. For more information You have created a pie chart that displays summarized data from the current found set. When you are finished with this lesson, close the file by choosing File menu > Close. 1 To modify a chart, switch to Layout mode and double-click the chart. Notes 1 You can choose a layout containing a quick chart from the Layout pop-up menu to display it later. The completed chart appears in Browse mode. For Options, select Show values on chart and Percentages. The chart preview updates to display the new title and chart type. In the Chart inspector, for Title, type Revenue by Company.

Filemaker pro tutorial relationships