For some developers who are new to FileMaker, they may not come from a background of having worked with SQL or some other query language. Creating joins on the fly, as data is needed, is a foreign concept. Yet, when you create a relationship within the Relationship Graph, you’re creating a join which will be permanent for the life of the file or until deleted. This isn’t the case with SQL based solutions.
With FileMaker, the notion of joins comes in the form of persistent relationships within the Relationship Graph. These persistent joins add to the complexity of your solution but stand at the ready to return whatever data you wish to present.
In this video, I walk through the process of breaking down how to extract specific data via relationships. It’s the dark arts of showing exactly what you want to show on screen or being able to isolate that data using a Go To Related records script step.
Whatever your needs are, knowing how to filter out your desired data is a key skill to have when working with FileMaker Pro.
Click the title or link to this article to view the video.