Dyce & Sons

Helping businesses with IT since 1993

fmp13box.png

FileMaker Meta Data Pt 3

Thursday, January 08, 2015

If you're working with old databases, one thing you may need to confront is lack of consistency with primary key naming, but you can easily sort the problem with a fairly simple custom function. Anybody for interested in PrimaryKey($tablename;True)?

fmp13box.png

Basic FileMaker Meta Data

Friday, August 22, 2014

Almost every table in a FileMaker file should have include a basic set of meta data fields. You might not need them to start with, but they can be awfully handy later on for all sorts of things. Everyone has their own personal take on ids and reference numbers, creation and modification dates, account names, and the tricks for making dealing with them as straightforward as possible.

So here's mine. I thought I'd start with id numbers and serial numbers.

Prev 1 2 3 4 5 6 Next