Bringing It All Together

You've just finished learning a lot about the various options and settings in FileMaker's Define Database window. At this point, it would be a good idea to take them for a test drive by adding some more functionality to your database. While you're at it, you'll get a chance to add a new field to an existing database (something you haven't done yet) and see how FileMaker respondssee Missing Fields below.

A private investigator has to deal with all kinds of characters. You've decided you might need a little help separating the good guys from the bad guys. Of course, Mom always said there's some good in everybody, so what you really need is a field that holds a Goodness Rating: George Costanza gets a zero, Mrs. Cleaver gets a five, and everybody else gets something in between. You want to make sure the rating is between zero and five, and you'd like it to be three unless you manually change it.

1. In the Define Database window, enter Goodness Rating in the Field Name box and, from the Type pop-up menu, pick Number. Then click Create.

   You now have a field to hold the goodness rating.

2. Click the Options button, which has now become available, and then select the Auto-Enter tab.

   The Auto-Enter options appear. You might have to switch to the Auto-Enter tab, if it isn't visible.

3. Turn on the Data checkbox. Then, in the text box next to it, type 3.

   Remember, this option tells FileMaker to place some fixed piece of information in the field when you first create the record. Since you're assuming people are generally a three, it makes sense to let FileMaker automatically fill in that value for you.

4. Click the Validation tab, turn on "In range" and enter 0 to 5 for the range options.

   This action tells FileMaker to expect goodness ratings between zero and five.

5. Uncheck "Allow user to override during data entry."

   You don't want to allow values outside the range at all.

6. Turn on "Display custom message if validation fails."

   A custom message makes this whole thing feel more personal somehow.

7. In the custom message box, type Please specify a Goodness Rating between 0 and 5.

   You may as well give a message that is as meaningful as possible. Since the user can't override this validation, the message is a statement, not a question.

8. Click OK, then OK again to close the Define Database window.

   You're back in your database again, and ready to test the Goodness Rating.

That about does it. You now have a database that handily tracks people, including how good they are, and you can search it, sort it, print it, zoom it, and generally have a good time with it. In the next chapter, you'll learn how to gussy it up.