relational database design with filemaker pro download

The original developer used an interesting technique to update records: Based on a relationship with four different factors, the QOO, for example, would be updated by simply resetting a value of 1 on a single field called RECALC. QOO is a number field, and auto calculates when RECALC is reset to 1. This solution by Petrowsky uses relationships to display related on the same layout, but could also be used to update related records in the same fashion.įor example, I recently took over a large, multi-user database that heavily uses relationship based data update information on Quantity on Order (QOO), Quantity on Hand (QOH), and similar fields. Source: Relationship Based Data Filtering – ISO FileMaker Magazine 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.

In this video, I walk through the process of breaking down how to extract specific data via relationships. These persistent joins add to the complexity of your solution but stand at the ready to return whatever data you wish to present. With FileMaker, the notion of joins comes in the form of persistent relationships within the Relationship Graph. Watch this free Matt Petrowsky video on how to set up relationship based data filtering for some great tips on using a data display technique that mostly works for smaller database apps (solutions):

Once you have absorbed and worked with FileMaker relational design, you may want to dive into some more complex examples: Relationship Based Data Filtering

Relational database design with filemaker pro download