Join Cris Ippolite for an in-depth discussion in this video Using the exercise files, part of FileMaker Pro: Relational Database Design.
- If you have access to the exercise files for this course, you might notice something a little bit different than normal. First of all, you'll see that we have two different sets of exercise files. That's because this course is version agnostic. That means that it's not tied to a specific version of FileMaker. As a matter of fact, the concepts that are covered throughout this course are relevant in FileMaker version 7, all the way up to the current version of FileMaker. So as a result, we've provided two different sets of files for you. On the folder on the top, you'll see they're called "FMP7".
That's the file format for FileMaker version 7, 8, 9, 10, and 11. So if you're using any of those versions of FileMaker, all of this content is relevant, but you'll want to use the files found in this folder. If you're using FileMaker version 12 or above, you'll want to use the exercise files in the "FMP12" folder. When you're watching the movie, if you'd like to jump to a specific chapter, you can just go to the folder with that same chapter name.
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.