FileMaker Focus Series

What You'll Learn	Register for this training: Online | By Fax

Data Modeling (Relationships) When you have finished this module, you will be able to: Break a real-world scenario into a set of entities and their attributes Identify cases where one-to-many or many-to-many relationships are appropriate Create an entity-relationship diagram (ERD) Create relationships between FileMaker Pro tables Understand relationship options View and manage related FileMaker Pro data via a portal Create complex relationships for filtering views of related data Working with Layouts When you have finished this module, you will: Be able to create and modify layouts using the Status Toolbar and basic layout controls Know how to set script trigger options for layouts and objects Be adept at setting auto-resize options for layout objects Know how to facilitate a user’s interaction with layouts using value lists Have practical examples for accessing the internet and displaying web pages using web viewer objects Understand how to use conditional formatting to alter the appearance of an object under specified conditions Calculation Functions When you have finished this module, you will: Be familiar with the most common and useful calculation functions Be able to create calculation fields Know how to use calculations for field auto-entry and validation Have experience using calculation functions in a variety of practical contexts Understand how to use custom functions and why they are useful Scripts When you have finished this module, you will know how to: Create scripts that interact with users, perform finds, and manipulate data Attach scripts to buttons Set up layout and object level script triggers Use the Script Debugger and Data Viewer to troubleshoot scripts Add error trapping routines to scripts Use script parameters, script results, and script variables Create scripted routines for generating related records Use loops to perform iterative tasks