search for books and compare prices
Tables of Contents for Advanced Filemaker Pro 5.5 Techniques for Developers
Chapter/Section Title
Page #
Page Count
Foreword
x
Acknowledgments
xi
The Relational Model
1
34
Databases as Vessels of Meaning
2
5
Roots of the Relational Model
7
8
Set Theory
7
5
First Order Predicate Logic
12
3
Overview of the Relational Mode
15
18
Objects
15
6
Operators
21
1
Union
21
1
Intersection
22<
1
Subtraction
22
1
Product
22
2
Join
24
1
Project
25
1
Restrict
25
1
Divide
25
1
Integrity
26
Null Values
27
2
Candidate Keys
29
2
Primary Keys
31
1
Foreign Keys
32
1
Summary
33
2
The Relational Model and FileMaker Pro
35<
32
Building Relational Systems with FileMaker Pro
35
5
Relational Closure Property
40
1
Relational Operators
41
15
Project
41
1
Restrict
42
<>1Joins
42
1
Natural Join (aka Inner Join)
43
1
Outer Join
44
2
Union Join
46
1
Cross Join
46
1
Cartesian Product (Multiplication, or Prroduct)
46
2
Difference
48
2
Division
50
5
Intersection
55
1
Union
55
1
Domains
56
3
Date Domains
57
1
Enforcing Other Domain Types
58
1
Scalar Values
59
1
Primary Keys
60
3
Referential Integrity
63
3
Restricted Deletes
64
1
Restricted Updates
65
1
Cascading Deletes
65
1
Cascading Updates
65
1
Summary
66
1
Normalization
67
18
Functional Dependence
68
2
First Normal Frm (1NF)
70
3
Second Normal Form (2NF)
73
3
Third Normal Form (3NF)
76
2
Boyce-Codd Normal Form (BCNF)
78
1
Fourth Normal Form (4NF)
79
2
Fifth N Normal Form (5NF)
81
2
Summary
83
2
Audit Trails
85
22
Capturing Changes to Fields
86
6
The Audit Log
92
5
Rollback Considerations
972
Types of Rollbacks
99
2
Rolling Back Updates to a Single Field
99
1
Rolling Back a Record
99
1
Rolling Back Changes Made by a Certain User
100
1
Rolling Ba Back a Table or System
100
1
Recreating Transactions since the Last Backup
101
1
Constructing a Rollback Mechanism
101
5
Summary
106
1
Relational Design
10722
Process Description
109
19
Entity Relationship Diagramming
114
6
Prototyping the Interface
120
2
Building the Structure
122
1
The XP Approach
122122
6
Summary
128
1
Database Security Issues
129
22
Guarding Against Physical File Access
130
16
Invisible Files
133
2
Protecting FileMaker Pro Masterrd Access
135
1
Binder to the Rescue
136
2
No New Relationships
138
1
ScriptMaker Issues
138
1
Those Pesky Value Lists
139
1
Binder Review<
140
1
Zen and the Art of Annoyance
141
2
Protecting Your Intellectual Property with Easter Eggs
143
3
A Little Help from Your Friends
146
2
External Functions
2
Summary
148
3
Secure Login Systems
151
36
The Basic Login System
152
15
The User Table
153
1
Setting FileMaker Security
154
2
Start7>Startup Scripts
156
1
Authentication Routine
156
3
Checking Privileges
159
1
Logging Activity
160
3
Patching Holes
163
3
Alternate Methods of O Files
166
1
The Secure Login System
167
19
Login and Password Authentication
169
3
Creating and Checking Privileges
172
3
The Admin Interface
175
1
<1Creating and Deleting Users
176
5
Creating and Deleting Privileges
181
2
Assigning Privileges
183
2
Other Features You Might Want to Add
185
1
Summary
1
Advanced Use of Portals
187
54
Portals and Relationships
187
7
Portal Setup Options
191
1
Deletion of Related Records
192
2
Selection Portals
16>194
11
Selection Portal Variation
202
3
Portal Filters
205
7
Multiple Portal Filters
210
2
Type-Ahead Portals
212
4
Highlighting Portal Rows
11
Highlighting Multiple Portal Rows
220
7
Portal Sorting
227
9
Extra Credit
232
4
Hidden Portals
236
4
Summary
240
1
Reporting
241
38
Year-Over-Year Reporting
242
8
Method 1 - Customer Table
244
3
Method 2 - Invoice Table
247
3
Data Warehousing with Utility Files
250
9
- Creating the Utility Table
250
1
Step 2 - Getting Data into the Warehouse
251
6
Step 3 - Accessing the Data in the Warehouse
257
2
Bucket Reports
259
12
Another Apper Approach to Bucket Reports
263
8
Charting
271
7
Task 1 - Pie Chart
272
5
Task 2 - Line Chart
277
1
Summary
278
1
Recursive Data Structures
38
One-to-Many Recursion: The Organizational Chart
280
10
The Data Accordion
290
8
Many-to-Many Recursion
298
1
The Product Database
299
16
Navigatinggating the Hierarchy
305
2
Calculating Inventory Levels
307
1
Quantity Received
307
2
Quantity Produced
309
2
Quantity Used in Production
311
1
Qy Shipped
312
1
Finishing the Job
313
1
Extra Credit
313
2
Summary
315
2
Complex Calculations
317
34
Text Manipulation Tools
318
9<>9
Number Functions
327
9
Date and Time Formulas
336
13
Summary
349
2
Appendix A References
351
4
Appendix B Keyboard Shortcuts and Other Time-Saving Techniz02>
355
8
Appendix C Glossary
363
10
Index
373
<