intermediate level

Design Patterns: Key Tables

Database Design, FileMakerGo, intermediate level, mobile, User Interface, WebDirect

This is the second part in a series discussing design patterns for Claris FileMaker databases. The first part discusses the use of data layers, check it out first if you haven’t read it already. What are Key tables, also known as “no data” tables? In this article we introduce Key tables. Key tables are an […]

Design Patterns: Key Tables Read More »

choose your favourite math operator

Using Boolean Data in Mathematical Functions

Calculations, Database Design, intermediate level, Scripting

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 »

Make Data Entry Easier by Framing Questions as a Boolean Option

Basic Level, Calculations, Database Design, intermediate level, Scripting, User Interface

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 »

Business Data Systems