Join Cris Ippolite for an in-depth discussion in this video Defining tables, part of FileMaker Pro: Relational Database Design (2011).
- In the data modeling exercise,…we determined that we needed four tables.…One for each entity.…In this case, it was the customer table,…an orders table, and a products table.…We also determined that we had…a many to many relationship,…which required us to add a new join table,…that we're gonna call the order line item.…So, in this movie we're gonna talk about…how to add these four tables…to your FileMaker database.…This is also the first time…in the data modeling process…that you're actually opening up…the FileMaker Pro application.…So, after opening up FileMaker Pro,…you'll go to the File menu…and select New Database.…
You'll see a dialog appear on screen…and FileMaker is asking you…what you want to name your new file…and where you want to save it.…So, we'll choose the Desktop…and we'll leave the name untitled.…Once we've made those decisions,…we can hit Save.…Now you'll notice that it's created…a FileMaker Pro database for us…and taken us to the Quick Table View…for our untitled layout,…but we're not done with our table setup.…
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.