Tips and tricks are usually small notes or demonstrations.
The recent upgrade Claris FileMaker introduced transactions. FileMaker has, until now, only been able to commit one data record at a time. In a relational database this “per record” approach has drawbacks. When we do something complex we may create several records, or create records in several different tables. Using FileMaker’s “per record” approach, each […]
Transactions in Claris FileMaker 19.6.1 Read More »
Button bars were introduced to FileMaker in 2015 with version 14 and they quickly became a favourite tool for managing many different layout and display jobs. The ability to display an SVG or PNG image beside a text label and link it to a script action made a mundane and laborious job easy and satisfying.
Many database applications are based on relationship models which are one-directional but there are other patterns that we will need from time to time. In this article we’ll discuss several common design patterns and then look at a more unusual pattern which can be used to handle situations which are difficult to structure or have
Reciprocal Relationships Read More »
If you want to use your Sites folder in your account as a location for web dev then you need to modify httpd.conf to allow that.
FileMaker Server 19: Configure Apache User Directories on Mac OSX Read More »
Data layers simplify common data modelling problems. Data layers share the same core data and typically include several extra attributes which are unique to that layer.
Design Patterns: Data Layers Read More »
If you are shy of maths you should check this article. Math-geeks know how useful these two simple math tricks are.
Using Boolean Data in Mathematical Functions Read More »
Learning to use boolean options can improve your database in important ways, via ease of input, data integrity, data storage and data re-use.
Make Data Entry Easier by Framing Questions as a Boolean Option Read More »
