From the course: FileMaker: Relational Database Design

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Difference between relationships and queries in FileMaker

Difference between relationships and queries in FileMaker - FileMaker Pro Tutorial

From the course: FileMaker: Relational Database Design

Difference between relationships and queries in FileMaker

- [Instructor] Okay, I'd like to take a moment to make an important distinction between the two different kinds of relationships that you may encounter in FileMaker. I'm very happy that you clicked on this movie because this is probably one of the most important clarifications that you're going to get when you're working with relationships in FileMaker Pro. So let's talk about that first. The only word that you'll see referenced in any of the interface in FileMaker is the word relationships. Specifically if you look at the relationship's graph. What we're looking at in this example is actually two different types of things. We see relationships. The customers to orders, orders to line items, and products to line items. Those are actually relationships. But where we see here are queries. We haven't gotten into those yet. I'm going to show you examples of queries in some of the upcoming movies. But that's the concept…

Contents