Join Cris Ippolite for an in-depth discussion in this video Using the exercise files, part of Relational Database Design with FileMaker Pro.
- 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