Database Schema & Business Logic

FQL - Internal SQL

FQL or FileMaker Query Language - local calls to your database using SQL syntax - using plug-ins.

External Data Sources

Implementing and utilizing External Data (SQL) Sources (ESS) in your solution.

Calculation Engine (Define Fields)

1. Function of the Day

Field Types, Field Options, and those wonderful Calculation Functions!

Relationships

Creating and developing relationships, creating children, avoiding orphans.

Managing Scripts

Writing efficient automated tasks with scripts, managing complex business logic, passing parameters, debugging and error trapping.

Finding & Searching

Using the find mode and or relationships to search or find record sets.

Importing & Exporting

Getting data in and out of FileMaker.

Value Lists

Working with value lists, pop up lists, conditional menus, radio buttons, and check boxes.

Custom Functions

1. fmfunctions.com,
2. Brian Dunnings' Custom Functions,
3. Custom Function Library

General Discussions on developing custom functions with FileMaker Advanced