Join Cris Ippolite for an in-depth discussion in this video Determining which tables need keys, part of FileMaker Pro: Relational Database Design (2011).
- We've discussed the concept of keys,…both primary and foreign,…and how they're critical…to building relationships in your database.…The next step is understanding which of your tables…will need these key fields defined.…Let's take a look at the ERD…that we've been talking about so far in this title…and determine what types of keys we'll need.…In review, we have five tables,…each with the relationships already defined.…The primary key decisions are easy.…Every table acting as a parent…needs a primary key.…Let's look at which tables are acting as parents.…
So, here we can see that…Companies are the parent to Contacts.…Contacts are the parent to Orders.…Orders are the parents to Order/Products…and Products are also acting…as the parents to Order/Products.…Therefore, all these need primary key fields.…Now, how do we determine which tables…will require a foreign key field?…Well, an easy rule to follow here…is that every child table needs a foreign key.…If you notice, you can identify the child tables easily…because they all have a double hash touching them.…
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.