3.3. Advanced Field Options

At this point your database is simple, but entirely usable. In fact, you could stop reading right now, and you'd be able to build super-simple databases to solve all kinds of problems. But the Fields tab in FileMaker's Manage Database dialog box has lots more settings to make your database even smarter, easier to use, and more consistent.

3.3.1. Auto-Enter Options

All your fields are completely empty when you create a new record. Often, but not always, that's what you want—a completely blank slate. With FileMaker, you have a handful of other possibilities. Suppose most of your clients are from Phoenix, for example. It would be nice if FileMaker could put Phoenix in the City field for you—you can always change it later. In fact, this situation is so common that every field has a group of Auto-Enter settings where you can tell FileMaker exactly what to put in the field for you (see Figure 3-8).