From Dwayne Wright PMP
Certified FileMaker Developer
A READER ASKS
I need a language value list, but there isn't one in FM 10 creation fields "options". I create a value list exactly in this form and I need to sort the field "thema" in this form.
numerical and alphabetical order of course not works
There is an option to sort a field by an accompanying value list. For the huge majority of the time, you will be sorting fields in ascending and descending orders. However the ability to sort via a value list can add some very interesting opportunities to your sort routines.
A sort by value list can be very helpful in the crafting of reports that might have grouped totals based upon a sub summary part. To sort a field by a value list, you click the field you want in the sort order. Next you click the radio button for Custom Order Based On Value List. From the pull down menu from that selections right, choose the value list you want to use.