Advanced FileMaker Pro

Duration: 2 Days


This two day course is aimed at those wanting to learn powerful techniques and best practice in FileMaker database design. It covers some of the less obvious features of FileMaker and emphases the creative use of relationships to build user-friendly interfaces and the efficient capture, display and output of data. The course draws on many tried and tested procedures used by FileMaker developers to create database systems that are both easy to use and that possess rich functionality when required.


Strong existing FileMaker Pro skills and a good understanding of relationships and scripting. This may be acquired through experience as a database developer or previous attendance on the equivalent Transmedia training course and follow up practice.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Going further with FileMaker Relationships (1)

  • The creative use of relationships
  • Using non-equijoin relationships
  • Multi-parameter relationships
  • Self relationships
  • Using relationships to create conditional value lists

Going further with FileMaker Relationships (2)

  • Achieving better information presentation through filtered portals
  • Controlling portals using relationships with global fields
  • Enhanced control using multi- parameter global field relationships

Looping and batch processing

  • The Replace command versus Looping techniques
  • Setting initial conditions; using fields with global storage; starting and ending a loop
  • Worked examples: (1) Updating a salary field; (2) Creating multiple user accounts at one time

Using Script Triggers

  • The principle and benefits of script triggers
  • Comparing the various trigger conditions for a script trigger (OnObject, OnRecord conditions, OnLayout conditions etc)
  • Simple demonstration example
  • More sophisticated examples including a “Type Ahead” portal search

The Data Separation Model

  • Understanding the concept
  • Benefits of data separation
  • Practical demonstration

Using the Execute SQL function

  • Understanding the concept
  • Structuring the query
  • Basic SQL commands used in FileMaker
  • Query tutorials

Tutorial Option - Best Practice For Building A Solution

  • Planning the solution; tables and relationships
  • Creating user-friendly navigation
  • Creating filtered portals
  • Scripting as required
  • Building the solution: Option (1) - Creating a Restaurant Menu solution; Option (2) - Creating a Shopping Cart solution

Live Chat

Course Dates

RemoteLondon CentralLondon GreenwichBristol

Remote Training

Dates Price Book Now
8 - 9 Oct £360 + VAT Book Now
16 - 17 Nov £360 + VAT Book Now
See more dates...

London Central

Dates Price Book Now
8 - 9 Oct £545 + VAT Book Now
16 - 17 Nov £545 + VAT Book Now
See more dates...


Dates Price Book Now
15 - 16 Oct £545 + VAT Book Now
12 - 13 Nov £545 + VAT Book Now
See more dates...

All our courses run in London and Bristol, or can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260
All prices are per person and are subject to VAT
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)

Exams and Certification

The knowledge gained on this course is a valuable contribution towards passing the FileMaker Pro Certification Exam (more at, allowing a successful candidate to become an FileMaker Certified Developer.

"I wish all training courses were run this well!"

RPS Design

"Excellent. The right pace, the right style- great overall!"

Goldsmiths University of London

"Concepts were explained clearly - very much so. What a great instructor! "

Jason Mather

© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260       Privacy Policy