Adding tables to the relationships graph
All tables used in relationships must appear in the relationships graph. This includes tables from external files. By default, a new file contains a table with the same name as the file.
To add a table to the relationships graph:
With the database open, choose File menu > Manage > Database.
To add a table occurrence from an external file, click the Data Source list and do one of the following:
Choose Add FileMaker Data Source to select another FileMaker Pro file using the Open File dialog box. This is the quickest method of adding an external FileMaker data source.
Choose Add ODBC Data Source to select an existing ODBC data source. See Editing ODBC data sources for more information about ODBC data sources.
Choose Manage Data Sources to open the Manage External Data Sources dialog box. Use this method to add multi-path FileMaker data sources and ODBC data sources or to edit, duplicate, or delete existing data sources. See Connecting to data sources for more information on defining and managing external data sources.
Each table occurrence in the relationships graph must have a unique name.
Related topics 
About relationships
About the relationships graph
About planning a database
About the types of relationships
About match fields for relationships
Creating relationships
Changing relationships
Defining database tables