Learn FileMaker Pro 7

Jonathan Stars9781556220982, 1-55622-098-7

FileMaker Pro 7 is a radical update to this award winning database program. Essential not only to beginners but also intermediate users and professionals needing to get up to speed with all the changes, this book covers all of it.

---

Table of contents :
Team DDU……Page 1
Contents……Page 4
Preface……Page 16
About the Authors……Page 18
Acknowledgments……Page 19
Introduction……Page 21
Part 1 Learning the Basics……Page 26
Introduction……Page 27
What Is a Database?……Page 28
Opening FileMaker Pro……Page 29
Opening a FileMaker Pro File……Page 30
Files……Page 31
Tables……Page 32
Fields……Page 33
Layouts……Page 34
Saving a Copy of a FileMaker Pro File……Page 35
Summary……Page 36
Introduction……Page 38
Tables Tab……Page 39
Fields Tab……Page 40
Relationships Tab……Page 41
Lookups……Page 44
Layout Mode……Page 45
Layout Types……Page 47
Find Mode……Page 48
Sort Command……Page 49
ScriptMaker……Page 50
Accounts and Privileges……Page 51
Summary……Page 52
Introduction……Page 54
Planning the Database……Page 55
Planning This Database……Page 56
Adding Some Fields……Page 57
Adding Field Options……Page 58
Cleaning Up the Layout……Page 60
Format Painter……Page 61
Duplicate……Page 62
Layout Toolbars……Page 63
Object Grids……Page 64
Size Palette……Page 65
Alignment……Page 66
Locking Objects……Page 67
Simple New Record Script……Page 68
Simple Find Script……Page 69
Assigning Scripts to Buttons……Page 71
Special Situations……Page 73
Summary……Page 75
Part 2 Using FileMaker Pro……Page 78
Considerations……Page 79
Creating Your Own Database……Page 80
About Field Names……Page 81
The Eight Field Types……Page 82
Time Field……Page 83
Container Field……Page 84
Calculation Field……Page 85
Summary Field……Page 86
Global Storage Option……Page 87
Repeating Field……Page 89
Date Format……Page 90
TextFormat……Page 91
Summary……Page 92
Introduction……Page 94
Selecting the Record……Page 95
Selecting the Field……Page 98
Using Tab Order……Page 99
Insert……Page 101
Drag-and-Drop……Page 102
Using Value Lists……Page 103
Insert Picture……Page 105
Insert Sound……Page 106
Replace Command……Page 107
Find/Replace……Page 108
Deleting Data……Page 110
Summary……Page 111
Introduction……Page 113
Many Tables-Relational Design……Page 114
Define Your Tables……Page 115
Determine Your Match, or Key, Fields……Page 117
Making the Relationship……Page 118
Relationship Tools7……Page 120
Tool Icons……Page 122
Allow Creation of Related Records……Page 123
Parent and Child……Page 124
Allow Deletion of Related Records……Page 125
Sort Related Records……Page 126
Drawing the Portal……Page 127
Placing the Fields in a Portal……Page 128
Adding Data to a Portal Field……Page 129
Investigating the Related Table……Page 131
Relating a Table Back to the Parent Table……Page 133
PerformingaFindinaPortal……Page 134
Deleting a Record from a Portal……Page 135
Before We Go……Page 136
Summary……Page 137
Introduction……Page 139
ER Diagram……Page 140
One-to-One Relationship……Page 141
Many-to-Many Relationship……Page 142
The Join, or Link, Table……Page 143
Multiple-Criteria Relationships7……Page 144
Unequal Relationships7……Page 145
Other Notes……Page 146
Invoice System ER Diagram……Page 147
Create the Tables……Page 148
Product Table……Page 149
Invoice and InvLI……Page 150
InvLI and Product……Page 151
AddtheLookups……Page 153
The Invoice Layout……Page 154
Products Pop-up……Page 155
Customers Pop-up……Page 157
Other Considerations……Page 158
Summary……Page 159
Introduction……Page 161
Methods……Page 162
Less Than (