Course Details
Course Duration – One day
Course Objectives
This course covers advanced calculations, data auto-entry, validation, and relationships. You will build advanced layouts and work with complex scripting functions. The course also includes networking functions, such as Web publishing, user accounts, and database security.
Course Content
Field options
- Advanced value lists
- Advanced calculations
- Field auto-entry
- Field validation
- Container fields
Many-to-many relationships
- Relationship types
- Many-to-many relationship formation
- Lookups
- Related table summary
Advanced layouts
- Layout efficiency boosters
- Layout parts
- Object appearance
- Merge fields
- Field entry behaviour
Complex scripts
- Chained scripts
- Related record scripts
- Intercepting errors
- Script parameters
- Script problems
Networking databases
- Database security
- Multiple user access
- Web publishing
Complex relationships
- Self-joining relationships
- Dependent value lists
- Multiple relationships to one table
- Complex criteria relationships
Prerequisites
FileMaker Pro – Basic, or equivalent knowledge.