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

London CentralLondon GreenwichBristol

London Central

Dates Price Book Now
11 - 12 Sep £545 + VAT Book Now
10 - 11 Oct £545 + VAT Book Now
12 - 13 Nov £545 + VAT Book Now
See more dates...

London Greenwich

Dates Price Book Now
4 - 5 Sep £545 + VAT Book Now
30 - 31 Oct £545 + VAT Book Now
20 - 21 Nov £545 + VAT Book Now
See more dates...


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

"Our trainer was very approachable and knowledgeable."

Bond Pearce

"Extremely friendly and helpful. Excellent knowledge and presentation."

Just Digital

"The trainer's knowledge was very strong and he was able to answer all my questions. Admin staff were very friendly and helpful."


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