Welcome To DwayneWright.com!
FileMaker Developer & Trainer ( formerly known as LeSaux Media Services )


Training Products | Training Classes | Consulting & Support | Solutions | Store | Home



Main | Articles | Movies | Examples


SELECTED PASSAGES FROM
THE FILEMAKER 7 GUIDE
TO RELATIONAL DESIGN
Would You Like A File Or A Table?
FMP7 Entities And Attributes Explored
FMP7 Tables And Occurrences Explored
FMP 7 Relationship Graph Explored
Relationship Graph Explored ( part 2 )
SELECTED PASSAGES FROM
THE FILEMAKER 7 GUIDE
TO SECURE DESIGN
Introduction To FileMaker 7 Security
Basic Tips For FileMaker 7 Databases
Security Levels By Function
What Is Record Level Security?
Testing Your Security Settings
Lions, Tigers And Bears (oh my!)
Plan Your Security, Secure Your Plan
Advantages Of FileMaker 7 Security
FileMaker 7 Security Starts Here
FileMaker 7 Accounts

Creating FMP7 Accounts And Scripted Mgmt
Introducing FMP7 Privilege Sets
Record, Layout, Value List & Script Privileges
Privilege Sets In Regards To (print, export & etc... )
About Extended Privilege Sets
Various Other Privilege Set Topics
Design Techniques To Add A Security Layer
Layout Settings That Add A Security Layer
 


SELECTED PASSAGES FROM THE GUIDE TO
FILEMAKER 6
CALCULATIONS
Introduction To FileMaker Calculations
The Calculation Dialog Box
Basic Introduction To Functions
Nesting A Function In A Function
Types Of FileMaker Functions
FileMaker 6 Text Functions Explored
FileMaker 6 Number Functions Explored
FileMaker 6 Date Functions Explored
FileMaker 6 Time Functions Explored
FileMaker 6 Aggregate Functions Explored
FileMaker 6 Summary Functions Explored
FileMaker 6 Repeating Functions Explored
FileMaker 6 Financial Functions Explored
FileMaker 6 Trigonometric Functions Explored
FileMaker 6 Logical Functions Explored
FileMaker 6 Status Functions Explored
FileMaker 6 Design Functions Explored
Quick FMP6 Tips, Tricks & Troubleshooting
Logical Operators and Politics?

Discussion About Indexing
What is Parse, Array & Concatenate?
Some Of My Favorite FMP6 Functions
Third Party Plug-Ins vs FMP Functions
ScriptMaker And Status Functions
Assorted FileMaker 6 Function Facts
Five Examples Of FMP6 Functions ( 1 )
Five Examples Of FMP6 Functions ( 2 )
Five Examples Of FMP6 Functions ( 3 )
Five Examples Of FMP6 Functions ( 4 )

Five Examples Of FMP6 Functions ( 5 )
Five Examples Of FMP6 Functions ( 6 )

PatternCount Investigated


CHAPTER 1 OF THE GUIDE TO
FILEMAKER 6
RELATIONSHIPS
Relational Database History
Say Hello To Your Entity
Could You Model That Database?
ER Diagrams and Attributes
Keys to A Good Relationship
Planning Database Relationships
One to One - One to Many
One to Many to One - Many to Many
Universal, Filtered & Self
About Flat File Databases
Sure It's Normal - Abby Normal
Normal In the First
Normal In the Second
Normal In the Third
Chapter 1 Quiz Questions
Chapter 2 - Important Field Info
Chapter 2 Quiz Questions
Chapter 3 - Field Options

SELECTED PASSAGES FROM
THE GUIDE TO FILEMAKER 6 PORTALS
Dealing With Broken Relationships
3 Reminders About Portals
Scripting And Portals
Dealing With FileMaker Portal Snap
Dealing With Portal Latency Refresh

New Related Record Via Hidden Portal
Sorting Portal With GetField Function
Portal Sorting Via A Calculation
Aggregate Totals In Portal Row
Go To Related Record ( GTRR )
Portal Shows What Has Not Happened
Portal Data As Text
Simple Portal Filter
Value Lists And Portals
Mark Portal Rows & GTRR ( single user )
Mark Portal Rows & GTRR ( multiple users )

SELECTED PASSAGES FROM
THE GUIDE TO FILEMAKER 6 SCRIPTING

Layout Buttons With Script Options
Nested IF vs Sequential IF

FileMaker Many To Many Relationships
Scripting Finds / Searches With FileMaker
Tabbing Using The Enter Key In FileMaker
FileMaker's Show Custom Dialog Box Explained
Portal Row Buttons Within Fields
Multiple File Script Linking To Main File


FROM THE GUIDE TO
FILEMAKER 6
SOLUTION PUBLISHING

Introduction To Solution Publishing

It's Not Money For Nothing
FMP Customers & Other Customers
The Fundamentals Of Business Setup
Keeping The Books / Office Space
Equipment & Phone Systems
Professional Services & Employees
Building A FileMaker Solution
The 1.0 Version Of Your Solution
The "D" Word - Documentation
The Testing Of Your Solution
Writing The User Documentation
The Protection Of Your Solution
Future Releases Of Your Solution
Packaging Of A Software Solution
Packaging Of A Software Solution 2
Intro To Marketing A Solution
Traditional Marketing Methods
Newer Methods Of Marketing
A Little Old And A Little New
Order Taking And Sales
Some Other Solution Selling Options
How Much To Charge
Your Company Website
Other FileMaker Business Information
Introduction To The FMP6 Developer Tool
Putting The FMP6 Dev Tool To Use
FMP6 Developer Runtime & Kiosk
Renaming FMP6 Files And Retaining Links
Permanently Remove Structure Modifications
Custom Menus And Extension Mgmt
Binding FileMaker 6 Solutions
More About FMP6 Runtime Solutions
Publishing Technical Aspects (part 1)
Publishing Technical Aspects (part 2)
Publishing Technical Aspects (part 3)



SELECTED PASSAGES FROM
THE GUIDE TO FILEMAKER 6 FOUND SET
About FMP 6 Found Set Discussions
About FMP 6 Fields
Indexing Of A Field Explored
Status Functions Need To Be Unstored
Found Set Quiz Questions (1-7)
Found Set Quiz Answers (1-7)
Find Mode Explored
FMP6 Search Operators
Five Date Range Example Files
Two More Examples Using Search Operators
Searching For Unique Or Duplicate Values
Adding Omit To Searches
More About Finding Ranges Of Information
About Multiple Find Requests In A Search
Constrain Found Set (FMP6 and higher)
Extend Found Set ( FMP 6 and higher)
Introduction To Scripting The Find Process
Found Set Quiz Questions (8-17)
Found Set Quiz Answers (8-17)

Basics Of Sorting Records Explored
Sort Dialog Options Explained
Sort Order Via Value List Explored
Sorting Discussion Wrap Up
Found Set Quiz Questions (18-24)
Found Set Quiz Answers (18-24)

Importing Data Into FileMaker Explored
A Pair Of Basic Importing Examples
Importing Data Concerns
Import Folder Full Of Data
Exporting Of Data Explored
Found Set Quiz Questions (25-31)
Found Set Quiz Answers (25-31)
Working With Found Sets Of Data
Duplicating Found Sets Of Data
Deleting A Found Set
Cascading Delete Relationship Setting
Copying A Found Set Of Records
Found / Replace Command Explored
Lookups And Data In The Found Set
Using The Replace Command
Potential Replace Issue - Record Locking
Parse Array And Concatenate
Found Set Quiz Questions 32-39
Found Set Quiz Answers 32-39
Using ScriptMaker In Record Searches
Scripting Your Own Search Process
Status Area (hiding, showing and mimicking)
Scripted Finds Need Inserted Find Ranges
Canceling / Aborting A Scripted Find
Creating A Layout Specifically For Searches
Three Scripting Custom Find Examples
Performing Finds In Portals
GTRR And Filtered Portals Linked To Found Sets
Found Set Showing Up In A Portal
Found Set In Portal Using Multiple Line Key Fields
Scripted OR Find With Portal Display
Mark Portal Rows & GTRR ( single user )
Mark Portal Rows & GTRR ( multiple users )

AND Searches In A Portal
Finding The Minimum Or Maximum Value
Found Set Of Quiz Questions 40 - 43
Found Set Of Quiz Answers 40 - 43
Search Tips, Tricks & Troublespots ( 1 )
Search Tips, Tricks & Troublespots ( 2 )
Controlling The Found Set Of Records
Search Tips, Tricks & Troublespots ( 3 )
Saved Searches & More In Scripts
Wrap Up Topic About Working With Found Sets
Found Set Of Quiz Questions 44 - 46
Found Set Of Quiz Answers 44 - 46
Exporting Field Labels Along With The Data
Example Solution: Used Cars

FROM THE GUIDE TO
FILEMAKER 6
MULTI USER DESIGN

Making Introductions
First You Will Need ...
Settings That Are Made
About Hosting The Files
Multiple User Design Techniques
About FileMaker Backups
Backup Method Pros & Cons
Backup Software And Media
Possible Issues ( Part 1 )

Possible Issues ( Part 2)
Possible Issues ( Part 3)
Multiple User Design Tips ( Part 1 )
Multiple User Design Tips ( Part 2)

FROM THE GUIDE TO
FILEMAKER 6
TERMS AND EXPRESSIONS

FileMaker 6 Terms Starting With ( A )
FileMaker 6 Terms Starting With ( B )

FileMaker 6 Terms Starting With ( C )
FileMaker 6 Terms Starting With ( D )
FileMaker 6 Terms Starting With ( E )
FileMaker 6 Terms Starting With ( F )
FileMaker 6 Terms Starting With ( G )
FileMaker 6 Terms Starting With ( H )
FileMaker 6 Terms Starting With ( I )
FileMaker 6 Terms Starting With ( J )
FileMaker 6 Terms Starting With ( K )
FileMaker 6 Terms Starting With ( L )
FileMaker 6 Terms Starting With ( M )
FileMaker 6 Terms Starting With ( N )
FileMaker 6 Terms Starting With ( O )
FileMaker 6 Terms Starting With ( P )
FileMaker 6 Terms Starting With ( Q )
FileMaker 6 Terms Starting With ( R )
FileMaker 6 Terms Starting With ( S )
FileMaker 6 Terms Starting With ( T )

FileMaker 6 Terms Starting With ( U )
FileMaker 6 Terms Starting With ( V )
FileMaker 6 Terms Starting With ( W )
FileMaker 6 Terms Starting With ( X )
FileMaker 6 Terms Starting With ( Y )
FileMaker 6 Terms Starting With ( Z )

FROM THE FILEMAKER 6 GUIDE
TO SECURE DESIGN
About These FMP6 Security Discussions
FMP6 Is ....
Controlling Access To FMP6 Solutions

Basic Intro To Password Access
Building Random Passwords
Password Action Control Options
Taking Away Menu Options
About FMP Password Settings
Creating Master And User Passwords
Steps For Creating A Blank Password
Changing FMP6 Passwords
About FMP6 Default Passwords
Wrapping Up FMP6 Password Discussions
It Is A Group Thing!
FMP6 Group Settings And Calculations
About Access Privileges
Access Privileges - Test & Troubleshoot
FMP6 Combination Plate Protection
You Cannot Lookup A Field Without Access
Cascading Delete Breakdown
Protect It With Design
Field Data Entry Validation
Locking FMP6 Records Via Design
Hiding Whole Layouts Or Parts Thereof

The Status Area And Modifier Keys
About Custom Built FMP6 Log In Systems
No Look Over My Shoulder Protection
About FMP 6 Security And Global Fields

Security By User Name - not recommended
FMP 6 Files That Open For A Limited Time
Creating A Serial Number System
Security Features Of The Developers Edition
Security Issues For Designers
Issues With Indexing And Value Lists

Dangers Of FileMaker Export Options
Web Companion, Default Passwords & More
Collection Of Other Possible Issues
Record Level Access Control
Dangers Associated With Record Deletion
Security Discussion Leftovers
Final Comments ( pre FileMaker 7 )

QUIZ FMP 6 SECURITY QUESTIONS 1 - 15
QUIZ FMP 6 SECURITY ANSWERS 1 - 15

QUIZ FMP6 SECURITY QUESTIONS 16 - 30
QUIZ FMP6 SECURITY ANSWERS 16 - 30
QUIZ FMP6 SECURITY QUESTIONS 31- 45
QUIZ FMP6 SECURITY ANSWERS 31- 45

QUIZ FMP6 SECURITY QUESTIONS 46 - 60
QUIZ FMP6 SECURITY ANSWERS 46 - 60


DISCUSSION ARCHIVE FOR TOPICS COVERING,
FILEMAKER 5.5 AND EARLIER
Button Options For Activated Scripts
Each Field Is A Related Record
Updating FMP5.5 Server Files
Copy, Compressed, Clone & Recover
FileMaker Housekeeping
10 TIPS FOR LAYOUT DESIGN
Formatting FileMaker Text
FileMaker 5 - Synching Records
A Before The Export To Do List
Exporting Sub-Summary Data/Fields
Supported FMPRO Export Formats
The Basics Of Exporting Data
Importing From Legacy Systems
Lost Time Importing From Clones?
Background Colors (boxes or parts)?
Get SubSummary Values in Browse
Building Nav-Tab-Bar Interfaces
Building Go/Do Boxes
Dynamically Format Text
Parsing out the first vowel
Building Conditional Value Lists
Passing Info Between Files
FMPro To Send 1 Email to Many
Improper Closes & Corruption
Tracking Improper Closes
User Corrupted Key Fields
Custom Layouts For Screen Sizes
Keyboard Shortcut Misfires
FileMaker Summary Fields
Advanced Reporting Techniques
Building External Engines (1 of 2)
Building External Engines (2 of 2)



Unauthorized reproduction in any form is strictly prohibited without prior permission. The material on this website is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this site. WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded.