Multi-File Relationships and External Sources

Beginner

Connect multiple FileMaker files as external data sources, understand the implications for relationship performance and portability, and manage cross-file dependencies.

What you'll learn

  • How to add external FileMaker files as data sources
  • How cross-file relationships affect performance
  • How to manage external source references when files move or are renamed
  • When to use multi-file vs. single-file architecture

FileMaker supports relationships across multiple files -- one file can include tables from another as "external data sources." This enables modular solutions: a shared lookups file, a separate archive file, or a dedicated reporting database. Multi-file relationships introduce dependency management and hosting constraints that single-file solutions avoid.

1/4
1

Adding an external data source

In File -> Manage -> External Data Sources, add the other FM file. You can reference it by path (absolute or relative) or by network URL. Relative paths ("file:../Lookups/Lookups.fmp12") are more portable across environments.

TEXT
// External data source configuration (File -> Manage -> External Data Sources):
// Name: LookupData
// Type: FileMaker
// File path: file:../LookupData/LookupData.fmp12
//           OR
//            fmnet://<server>/LookupData

// After adding the source, go to File -> Manage -> Database -> Tables tab
// Add a table occurrence pointing to the external source
Avoiding and Resolving Circular RelationshipsPortal Filtering with Relationship Keys

Sign in to track your progress and pick up where you left off.

Sign in to FM Dojo