Tutorials and Online Training Videos

FileMaker Pro 8: Intermediate Tutorial

FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical "how to" course by FileMaker expert, John Mark Osborne, starts from intermediate level and uses a single invoicing example to demonstrate FileMaker Pro features and techniques including interface design, relational database design, relationship operators, multiple predicates, table occurrences, portal filters, security, scripts, calculations, FileMaker Pro Advanced, multi-user solutions, record locking, multi-keys and deleting duplicate records. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning. To being learning FileMaker Pro 8 today, simply click on one of the links below.

The completed invoicing solution included on the beginner, intermediate and advanced FileMaker Pro 8 training is provided as a visual goal. Upon completion of all three titles, you will have created the exact same invoicing solution.

* Most techniques used in these videos are applicable to both FileMaker 8 and 7. Substitute techniques for FileMaker 7 users will be discussed when necessary.

** This tutorial is part two in a 3-part FileMaker Pro 8 series.


About John Mark Osborne
FileMaker 8 Family of Products
About the Tutorial Series
Why an Invoicing Example?

Interface Design

Screen Size
Tabs / Bars / Buttons
Field Outlines
Finishing Touches pt. 1
Finishing Touches pt. 2
Tabbed Layouts pt. 1
Tabbed Layouts pt. 2
List View
List View without Status Area
Design Considerations


Relational Theory
Data Modeling
Entity-Relationship Diagrams
Creating a Relationship
Related Fields pt. 1
Related Fields pt. 2
Many-To-Many Relationship pt. 1
Many-To-Many Relationship pt. 2
Creating a Portal
Portal Improvements
Two-Way Relationships
Completing the Interface

Table Occurrences

What are Table Occurrences? pt. 1
What are Table Occurrences? pt. 2
Filtered Portals
Calculated Portals
Date Range Portals pt. 1
Date Range Portals pt. 2
Table Occurrence Tricks
Conditional Value Lists pt. 1
Conditional Value Lists pt. 2
Scripts and Calculations pt. 1
Scripts and Calculations pt. 2
Organizing the Graph pt. 1
Organizing the Graph pt. 2


Complete Approach pt. 1
Complete Approach pt. 2
Privilege Sets pt. 1
Privilege Sets pt. 2
Extended Privileges
No Access Layout
Overdue Invoices pt. 1
Overdue Invoices pt. 2
Capturing Errors pt. 1
Capturing Errors pt. 2
Tracking Accounts pt. 1
Tracking Accounts pt. 2
Random Passwords
Override Account pt. 1
Override Account pt. 2


Menu Button
Script Parameters
Find Rolodex
Dynamic Messages
Duplicate Invoices
Dynamic Layouts
Print Invoice Layout pt. 1
Print Invoice Layout pt. 2
Print Invoice Script
Inventory Control


Grand Total pt. 1
Grand Total pt. 2
Basic Phone Filter pt. 1
Basic Phone Filter pt. 2
Phone Number Validation
Remove Text Formatting
Overdue Invoice Display
Parsing Text pt. 1
Parsing Text pt. 2
Field Level Tracking pt. 1
Field Level Tracking pt. 2
Parent and Child Tracking

FileMaker Pro Advanced

Advanced Features
Configuring Plug-Ins
Plug-In Examples pt. 1
Plug-In Examples pt. 2
Database Design Report
Developer Utilities
File Maintenance
Debugging Script pt. 1
Debugging Script pt. 2
Custom Functions pt. 1
Custom Functions pt. 2
Custom Menus pt. 1
Custom Menus pt. 2

Multi-User Solutions

FileMaker Server Sharing
Record Locking
Testing for Locked Records
Looping and Replace Scripts
Marking Records pt. 1
Marking Records pt. 2
Save a Found Set

Working with John Mark Osborne

Free Resources
Consulting and Meta-Consulting
Contacting Me

Related Books on FileMaker Pro 8: Intermediate

Save $80 on the
by Motorola with Verizon Wireless service for less than from Verizon Wireless directly.
Save $80 on DROID BIONIC
More Cell Phone Discounts