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

Creating relationships using FileMaker relationship graph and table occurrences - FileMaker Pro Tutorial

From the course: Learning FileMaker 16

Start my 1-month free trial

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…

Contents