So don’t expect every field to look the same. When you’re editing a record, the fields usually appear with the dotted outline shown in Figure 1-6, but you can turn this feature on and off, as described on Layout Setup. (But here’s a tip: If you want happy database users, make sure they can tell where the fields are and what goes in them.) In fact, if mystery is your thing, then you can make your field invisible-no label, no border, and no color. You can even give them rounded corners, so rounded that they look like little pills. You can color in a field with a solid color, a gradient, or a picture. A field can have a label next to, below, above-even inside-where you enter data, or no label at all. The techniques in this section work the same way whether you’re creating a new database or adding to an existing one.įields always appear inside the content area, but other than that, they can have amazing variety.
#FILEMAKER PRO ADVANCED 14 WIN ZIP#
First name, last name, phone number, street address, city, state, Zip code, and her subscription’s expiration date are all examples of fields each record can include. Since you store many smaller pieces of information in each record (like a person’s phone number, address, birthday, and so on), FileMaker lets you give each record an almost infinite number of fields-the specific bits of data that define each record.įor example, each person in a database of magazine subscribers gets her own record. Each record contains everything the database knows about that person, auction, product, or student. Whether your database contains information about individual people, eBay auctions, products you sell, student grades, or whatever, FileMaker always thinks of that information in individual chunks called records. Now that you understand the basic components of a FileMaker database, it’s time to start adding your own information. (The Mode pop-up menu is the most popular way to mode-hop, but you have plenty more options see the box on Changing Modes.) You can also glance at the Mode pop-up menu to see which mode you’re currently in. Your FileMaker window instantly switches to the new mode. Click it and choose one of the four modes. It appears near the bottom-left corner of Figure 1-1, displaying Browse mode. The Mode pop-up menu is the easiest way to change modes. Get more info on Preview Mode and Printing. It shows a one-page-at-a-time view of your data exactly as it’ll appear when printed. If you’re ever curious about how something will look when printed, switch to Preview mode. Once you’ve put all that information into your database, eventually you’ll want to print something out, like a set of mailing labels or a batch of invoices. Part Two of this book is all about Layout mode. Layout mode is where you design the screens (called layouts in FileMaker parlance) that present your database information to best advantage. In addition to using databases (viewing, finding, sorting, adding, and changing data), you can use FileMaker to build databases (in fact, that’s what most of this book is about). (For more details on finding specific records, see Finding Records.) You tell FileMaker what you’re looking for when it’s done looking, FileMaker returns you to Browse mode and shows what it found. Use Find mode to let FileMaker do the looking for you. When you have a lot of data, looking through it all for a particular bit of information can be tedious. Browse mode is the view shown in all the figures so far, and it’s where you’ll spend most of this chapter. In this mode, you add, change, and view your data. Browse mode is the one you see when you first open a database, since it’s the one you use most often.