From the course: FileMaker Pro Essential Training

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Sorting with multiple criteria

Sorting with multiple criteria - FileMaker Pro Tutorial

From the course: FileMaker Pro Essential Training

Start my 1-month free trial

Sorting with multiple criteria

- [Instructor] Often when you're working with FileMaker, and you have a large set of records, you may want to look at them in a certain order. This of course is where sorting comes into play. And sometimes when you're sorting, you might have multiple different criteria that you need to sort with. Say, for example, we've got this database with 1,523 records in it. And I sort them all by state in ascending order. And if we scrub all the way to the beginning we'll see that all the As, whatever state that is, all the way down to Wyoming at the end. So let's say however, though, that within each sort group, so that means within all the AAs, I would like to sort another value. Let's call it city. It's pretty simple to do. All you do is you keep your primary sort on the top of the sort order and I'm going to double-click on another value, city, which means that sort all of the records in the found set, this happens to be…

Contents