This method of sorting is based on the Sort Records by Field script step. Go to a field and use Sort Records by Field without a parameter and the records in the found set will sort by that field. For additional functionality and visual indicators this technique also uses the Hide Object feature, global variables, and conditional formatting. It is simple to replicate and only requires one short script to manage any number of list layouts. Download the sample file and check it out.
FileMaker Forever is a resource for FileMaker enthusiasts. Come here often for tips and sample files to help with your own projects. Created by Brent Durland with Swingtree Consulting