Join Cris Ippolite for an in-depth discussion in this video Understanding related fields , part of FileMaker Pro: Relational Database Design (2011).
- We've been talking a lot about creating relationships…between a parent and child table,…but for the rest of this title…we're gonna talk about the many things…you can do inside of your database…once those relationships are in place.…One of the primary benefits behind…the concept of relational databases…is to reduce redundancy and even borrow data…from other related tables.…For example, in this file that I've got on my Orders layout,…if I go into Layout Mode…I can see that this relationship has…what I like to call the context.…And let me explain that further…by clicking on the Modify Layout button.…
And you'll see the first thing that we notice…in any layout in the Layout Setup dialog…is the name of the layout,…which is immediately followed…by the table that it's based on.…That means that the Orders layout…has the context of the Orders table.…Another way to look at this…is under the File, Manage, Database option,…over in the Relationships tab.…You should always remember that at any given point…when a user is in your database…
The course applies to versions of FileMaker Pro from 7 through the most current version.
- Reviewing relationships types
- Diagramming relationships
- Resolving many-to-many relationships
- Determining which tables need key fields
- Defining tables in FileMaker Pro
- Using the Relationship Graph
- Using multiple match fields in one relationship
- Using global fields to filter portals
- Creating self relationships
- Creating aggregate functions using relationships
Skill Level Intermediate
Q: The exercise files for this course do not work on a Mac. It downloads executable files. Can you provide a workaround?
A: The files provided for this course were made pre-FileMaker Pro 12. The system does not recognize the .fp7 files immediately as something that can be opened with FileMaker Pro 12 and instead shows them as Unix Executable Files.
The solution is quite simple. Just double-click the file, at which point the Mac will prompt you to choose an application to open the
file with. Select FileMaker Pro 12 and it will then convert the file from a .fp7 file into the new FileMaker Pro 12 file format, which is .fmp12.
Q: This course was updated on 5/12/2015. What changed?
A: We moved a video from the "Using Relationships" chapter of FileMaker Pro 13 Essential Training into this course, where it will remain evergreen.