From the course: FileMaker Pro 12 Essential Training
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Understanding multipredicate relationships - FileMaker Pro Tutorial
From the course: FileMaker Pro 12 Essential Training
Understanding multipredicate relationships
Relationships in FileMaker can and should be used to implement the basic primary key to foreign key relationships, indicated on any entity relationship diagram. We've already discussed using the relationship graph to plot out our tables in our database, and also created relationships between those tables. You can see those here. And up until this point, we haven't had to modify any of these, so our relationship graph at the moment looks exactly like our entity relationship diagram did, and that's because the only table occurrences that we see on screen here are the ones that represent the individual base tables. But that's the key. These are just table occurrences, and the reason they're not called tables in the relationship graph is because you can actually add multiple occurrences of any one table. So why would we want to do that? Well, this is probably the closest thing to an intermediate topic in this entire title, so we don't want to scare you off. If you're comfortable with your…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.