In addition to executing a Find with a single criterion, you can specify multiple criteria. You can search for records that satisfy any of the criteria (an Or search) or records that meet all criteria (an And search).
You can also perform a Find that locates records within a range, such as all people between the ages of 18 and 21.
flat file vs. relational p. 5
Conceptually, flat-file databases are much easier for new users to understand. While more powerful and flexible, learning to create relational databases has a much steeper learning curve.
The FileMaker database you'll make in this book is a simple relational one. For a flat-file database tutorial, see my previous book: Creating a Database in FileMaker Pro: Visual QuickProject. While written for FileMaker Pro 7, its database can also be constructed in FileMaker Pro 8.
about FileMaker Pro p. 6
A FileMaker layout can include as many or as few of the defined fields as you like. Think of a layout as simply one view into the database.
There is no requirement that a given field be included in any of a database's layouts. Some fields are intended only to be part of a calculation, for example.
The addition of simple scriptsoften only a single stepcan greatly enhance a database's ease of use. For example, you can create one-step scripts to switch to a particular layout, create a new record, delete the current record, or restore the database to a default sort order.
In FileMaker Pro, scripts can be executed by choosing the script name from the Scripts menu or by clicking a button to which the script has been attached. The first ten scripts in the Scripts menu can also be run by pressing a -key or -key combination.
Any FileMaker database can have a when opening or when closing script that automatically runs whenever the database is opened or closed.