Subtitles of the Movie

I am going to close this segment of the tutorial by looking at sorting records that something that you frequently do in a database and it make can your life very easy FileMaker is very very efficient of sorting records and in order to sort records I come up here to the records menu and I choose ******* sorts command and this dialogue lets me choose how to sort the data at the very beginning if you never sorted the data before their will be nothing in this sort order. So I have the fields over here on the left that are in the database and this interface that's you are seeing here with fields on one side and selected fields on the other side is very commonly used in FileMaker. I am going to sort this database by last name, I select the field over here and move it over and I can choose whether if I select that field I might sort it in ascending or descending order. I can also create custom order ****** just going to talk right now for ascending or descending orders because they are always available and then I can choose the first name and click move to move it over here or I can just double click and little move over it is text field so by default it's going to sort by in ascending order. so if I would to sort the database now what would happen is that be sorted by last name and then by first name. so I click on the sort button and now go to the first record of the database and you will see well you sort of see these this is really hard to keep track of the fact that sorted this way. This way of viewing the database really is in conducive to seeing the sort order and that's one of the reasons that you can go back up to the view menu and choose view as table and now I see all the data together it's very easy to say that it's been sorted by last name and I can't tell because I have no duplicate last names and the database as I am not constructed it will not allow for duplicate last names, but with any each last name the first names are sorted after that ******. So I have created to sort for the database if I go back into sort record I will see the last sort I can clear all of this and maybe I want to, lets say this is informal I just want to sort by first name again I can click move or I can double click sort here I am sorted by first name. Now when I first showed you the table view I showed you that the top of each column can be used to sort. If I go up here I am now sorting by last name if I come up here to sort records the last sort order was last name, I sort by first name the last sort order was first name. What you are seeing here is that FileMaker intergrades it's features very thoroughly I can sort from the sort command in the records menu, I can sort from the top of the column in some but not all table views and I can sort from scripts I can sort from buttons on the layout so it is very flexible way of working. Back to the sort menu. In this dialogue I can select the field I can choose the sort order and I can over write the language for the sort, this is important particularly with regard to Unicode. Now Unicode is way of encoding characters by default what FileMaker is going to do is to ignore capitalization and it's going to sort certain characters in certain languages in certain orders. If you want to make every character a different character that is to say capital 'D' is a different character from lower case'd' sort using Unicode for the field language. Now the last button I am going to talk about here is the unsort button which puts the records in the database back into the order in which they were created and that's sorting.