From the course: Learning FileMaker 16
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Creating relationships using FileMaker relationship graph and table occurrences - FileMaker Pro Tutorial
From the course: Learning FileMaker 16
Creating relationships using FileMaker relationship graph and table occurrences
- [Instructor] Once you have all your key fields defined and you've evaluated what your relationships are, creating the relationships themselves in FileMaker is rather easy. What you do is you go into the Manage Database dialogue under the File menu and then click over to the Relationship tab. This is the first time that we've looked at this tab, and you'll notice that we have four boxes in here, much like in our entity relationship diagram, each one of these boxes represents a table. Specifically, they're called table occurrences, but in this case, it could very much look like our ERD. As a matter of fact, if we move things around ever so slightly, we'll see that we have Customers and Invoices, and then, Products over here. We can actually kind of make it look like our ERD, which isn't a bad exercise 'cause then it kind of organizes things just like you had it in your diagram. It has no functional capability whatsoever by moving these around, but I kind of like to do that to make my…
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.