A READER ASKS: Sorting By Language Value List

© 2010 Dwayne Wright - dwaynewright.com
From Dwayne Wright PMP - Certified FileMaker 10, 9 & 8 Developer
EMAIL: info@dwaynewright.com     TWITTER: dwaynewright

APPENDIX 1: A Reader Asks

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

a
b
g
T
k
t
r
s
u
S

-------
DWAYNE RESPONDS
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.