Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In FileMaker Pro 11 Essential Training, Cris Ippolite demonstrates the principal features and functions of this popular database software, including creating tables and relationships, managing fields and records, and working with layouts. The course shows FileMaker developers how to find, sort, and share data as well as how to create reports, calculations, and scripts. It also covers brand new features in FileMaker Pro 11 such as the Inspector tool, charting, and portal filtering. Exercise files accompany the course.
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 values on top of each other inside the sort order, but the order in which they appear is pretty critical to the way that it sorts.
So first it's going to sort by State, and then only if they find matches within records in the State field, it will then sort those matched records by City. You can add another level here if you want, but the only time it's going to sort is if the State values match in records, the City values match in records, and then it will kick into yet another sort value. So in this case, we don't have a lot of duplicate cities, so it won't make much more sense to sort beyond just two values, but you certainly can. So in cases where you need to sort within a sort group, just use multiple criterion in your Sort dialog box.
Find answers to the most frequently asked questions about FileMaker Pro 11 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.