From the course: FileMaker: Relational Database Design
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using operators in query relationships - FileMaker Pro Tutorial
From the course: FileMaker: Relational Database Design
Using operators in query relationships
- [Instructor] In this chapter, we've been looking at query relationships in FileMaker, and just as a quick refresher, if we go into the Manage > Database window for the exercise file, we see that we've got all our base table relationships. In a previous movie, in case you want to go back and check it out, we created a query relationship. Now, the difference between a base table relationship, which has a primary key and foreign key relationship only, a query relationship has the primary key and foreign key, sometimes it doesn't have those, by the way. But in our cases, we've got primary key and foreign key AND, specifically you see the word AND there, we have other criteria. Now, in the previous example, we looked at PK equals FK and Shipped.c equals Shipment Status, but I want to show you another example where we can use additional operators, not just equals. Going back to the Browse mode for a second, you see we have a portal here that shows all of the orders for this customer. This…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.