Sorting Records

Your Rolodex may be limited to an alphabetical (by last name) arrangement, but a FileMaker database has no such limitation. You can sort the records in any order you want, as often as you want. You can even do a sort-within-a-sort, as you'll see later in this section.

The process always begins the same way: Choose Records Sort Records. Youll see the Sort Records dialog box shown in Figure 2-7.

The Sort Records window lists all fields in your current layout on the left. Use the pop-up menu at the top of the list to switch to a list of all the fields in the table that are tied to the current layout. See Section 7.3.5.7 for details on tables and layouts. You tell FileMaker what to sort by moving the field to the list on the right. For example, if you're in need of a short-term loan, you may find it useful to sort your contacts by annual income, so you'd start by clicking the annual income field.

The steps below, though, show a more common examplesorting by Last Name:

1. Choose Records Sort or press Ctrl+S (-S).

   The Sort Records dialog box (Figure 2-7) appears.

2. Select the Last Name field from the list on the left, and then click Move.

   The field name appears in the Sort Order list on the right. You can save a little mouse-mileage by double-clicking a field on the left instead of selecting it, then clicking Move.

3. Click Sort.

   FileMaker sorts the records in the traditional alphabetical-by-last-name order. You can tell by flipping through the records or switching to Table view.

Each sort field has an order associated with it as well. Right now, you only need to worry about two of these orders: "Ascending order" and "Descending order." You can click one of these radio buttons before you click Move and the field will have the setting by the time it makes it to the Sort Order list. More often than not, though, you'll move the field over before you think about the order. In this case, just click select the field from the Sort Order list and then pick the order. Each field in the Sort Order list shows a little bar-chart icon representing the order assigned to it, which matches the icons next to each radio button.

Tip: If you change your mind about one of the fields in the Sort Order list, click it. The Move button changes to say Clear, and a click removes the selected field from the list. If you want to remove every field from the Sort Order list, click Clear All.

When you're all done, click Sort. If you change your mind, click Cancel instead and FileMaker will forget everything you've done while in this window. Otherwise, the next time you choose the Sort Records command, the dialog box will show the same settings you used most recently.

The status area lets you know if your records are sorted (no surprise there). Below the Record Count, it says "Sorted" if you've done a sort, and "Unsorted" otherwise. (See the box on Section 2.5 to learn what "Semi-sorted" means.)

2.4.1. Multiple Sort Fields

FileMaker lets you pick more than one field to sort by, which comes in handy when you have lots of records with the same data in some fields. For example, if your People database gets really big, you might have several people with the same last name. If you just sort by last name, there's no telling in which order the like-named people will fall. In this case, it would help to sort by last name and first name.

When you use more than one sort field, the order the fields appear in the Sort Order list is important, because it determines which field FileMaker uses first. If you sort a list of family members by First Name, then Last Name, you might wind up records ordered like those shown at left in Figure 2-8.

If you sort by Last Name, then First Name, you'll get something like the window shown at right instead. In the first example, FileMaker sorts everything by First Name. When two people have the same first name, it then uses Last Name to figure out what order those two should be in. In the second example, the records are first sorted by Last Name instead. First Name is then used to figure out how to sort the folks with the same last name.

Since the order of the sort fields is so important, FileMaker provides a convenient way to shuffle them around in the Sort Records dialog box after you've added them to the Sort Order list. Figure 2-9 sheds some light on how it works.

If you do a multi-field sort and then discover you didn't get quite what you expected (because you had the fields in the wrong order), just choose Records images/U2192.jpg border=0> Sort Records again, move the fields in the Sort Order list to the right places, and then click Sort.