• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Sorting Records

FileMaker stores records in the order they were created but that’s no reason for you to work with them in that somewhat random order. By running a sort, you can rearrange the order for browsing, printing, or updating. FileMaker uses the found set concept discussed on page 50 to search through select fields and then arrange the records as you desire.

You can sort records using single or multiple criteria, just like finding records. FileMaker’s new contextual sort feature makes single-criteria sorts so simple that you’ll probably use it far more often than the actual Sort command. No matter which way you trigger a single-criteria sort, you can arrange your records in one of three ways: ascending order, descending order, or a custom order based on a value list you create. If, like me, you can hardly keep right and left straight, let alone what’s ascending and descending, How FileMaker Sorts What (Table 5.2) should help.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint