Course outline
Going further with FileMaker Relationships (1)• Getting clever: 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 global fields; 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 properties, OnRecord properties, OnLayout properties 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
Workshop Options
This section of the course takes place during the second half of the second day (depending on timings). Delegates may choose to work on their own solution or provided with a sophisticated development challenge if they do not bring in their own work!
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
