Sorting with multiple criteria


show more Sorting with multiple criteria provides you with in-depth training on Business. Taught by Cris Ippolite as part of the FileMaker Pro 11 Essential Training show less
please wait ...

Sorting with multiple criteria

Often when you're working with FileMaker, and you have a large sets of records, you may just want to look at them in a certain order. This, of course, is where Sorting comes in to play. Sometimes when you're sorting, you may have multiple, different criteria that you need to sort by. For example, you see here we've got 1,523 records, and if I sort them all by State - first clearing out any previous order I move state over and then hit Sort - you see that we've got a lot of duplicate matches within each state.

So what about if I want to see them by State, and then within State I want to see them sorted by City? That's pretty easy to do. Just go back into your Sort dialog as you saw moment ago, we can move another criterion. So now when I hit Sort, it's not only sorting within the State, as you see here, here's all that records for ME, and with each record for ME it's then sorting alphabetically by City, as well. You can continue to do this by layering multiple...

Sorting with multiple criteria
Video duration: 1m 36s 9h 11m Beginner

Viewers:

Sorting with multiple criteria provides you with in-depth training on Business. Taught by Cris Ippolite as part of the FileMaker Pro 11 Essential Training

Subject:
Business
Software:
FileMaker Pro
Author:
please wait ...