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 global fields; 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 properties, OnRecord properties, OnLayout properties 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

Course Dates

London CentralLondon GreenwichBristol

London Central

Dates Price Book Now
18 - 19 Jul £495 + VAT Book Now
6 - 7 Aug £495 + VAT Book Now
17 - 18 Sep £495 + VAT Book Now
See more dates...

London Greenwich

Dates Price Book Now
6 - 7 Aug £495 + VAT Book Now
24 - 25 Sep £495 + VAT Book Now
30 - 31 Oct £495 + VAT Book Now
See more dates...


Dates Price Book Now
13 - 14 Aug £495 + VAT Book Now
13 - 14 Sep £495 + VAT Book Now
15 - 16 Oct £495 + VAT Book Now
15 - 16 Nov £495 + 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 Developer Essentials for FileMaker 12 exam, allowing a successful candidate to become an FileMaker Certified Developer.

"Amazing! Looking forward to the follow-up course!"


"Exceptional knowledge base and tailored to suit our requirements."


"Absolutely top quality training and facilities."

National Museum of Wales

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