Course length: 1 day
Prerequisites: FileMaker Pro Introduction or equivalent knowledge.
Overview: You will learn powerful techniques for developing complex database systems containing multiple linked database files. You will also learn about the various relationship types, link databases together, use field formatting options, and will create buttons and scripts to create a system that is ultimately easy and efficient for an end user to work with.

Course content

Lesson 1: Advanced Field and Layout Options

• Advanced Field Definitions
• Creating a New Database
• Defining Fields
• Defining Fields with Serial Number Auto Entry
• Defining Fields with Date Auto Entry
• Defining Value Lists
• Defining Repeating Fields
• Creating Efficient Layouts
• Arranging Fields on the Layout
• Formatting Repeating Fields
• Formatting Value Lists on a Layout
• Making Final Layout Adjustments
• Manually Entering Record Data
• Importing Records
• Importing Records from Other Files

Lesson 2: Relating Databases

• Introduction to Relations
• Relationship Types and Terminology
• Examining Database Files
• Working with One-to-Many Relationships
• Defining Relationships
• Placing Related Fields on a Layout
• Defining a Bi-Directional Relationship
• Creating a Layout to Display Related Records from the "Many"File
• Creating a Portal to Display Related Records
• Viewing Related Records with a Portal

Lesson 3: Many-to-Many Relationships

• Establishing Many-to-Many Relationships
• Creating an Intermediate Database
• Defining Many-to-Many Relationships
• Displaying Related Fields in a "Bridge" Database
• Entering Information into the "Bridge" Database
• Utilizing Related Data
• Creating a Portal to Access Related Information in a Many-to-Many Relationship
• Defining Calculation Fields to Bridge a Many-to-Many Relationship
• Creating a Portal to View Registrations
• Summarizing Portal Records
• Creating a Count of Students
• Enhancing Portals
• Setting Up a Relationship to Allow the Creation of Related Records
• Creating a Value List from Another File
• Allowing the Deletion of Related Records

Lesson 4: Scripts and Buttons

• Creating Simple Buttons
• Creating a Button that Adds a New Record
• Creating a Button to Go to a Related Record
• Scripting
• Creating a Script that Includes Find Requests
• Creating the Final Script Layout
• Creating a Script to Go to Related Records
• Creating a Script to Omit Records
• Creating a Script to Switch Layouts and Print
• Chaining Scripts
• Combining Scripts and Buttons
• Attaching a Script to a Button
• Suppressing the Printing of an Object
  
  

Return to Courses