I have numerous records that define certain workshops. Each workshop has a "category" field. In an HTML View I am using a For-each loop to list the workshops. In the For-each loop I am using "sort by Category", and it works. However, I *also* want to sort the records inside each category alphabetically. Currently the records being displayed are grouped by category (which is correct), but inside each category the records are in a non-alphabetical order, which is distracting and difficult to use.
I'm guessing I could do some involved coding with nested for-each loops, or pre-build a list of records for each category, then sort each list alphabetically. But, I'm wondering (hoping) ZC has a friendlier automated way to do a double-sort on records (kinda like MS Excel allows 3-level sorting on spreadsheet records).
Any help or thoughts? Thanks.
Greg Malone
Santa Fe, New Mexico, US