Page Breaks and Sub-summary not based on first sort criterion
FMP Version 6.0v4 (for reasons out of our control)
Mac OS 10.5.8
I'm trying to have page breaks and a sub-summary part, based on a field that cannot be my first sort criterion.
My first sort criterion is a field of "sequential numbers" (so that the sequence of records appears in the order we want).
But I'd like the pages to break based on a field of "categories"(sequential numbers group all by category, but not alphabetically).
A sort by "sequential numbers" with a page break, yields only one record per page. A sort by "categories" yields the desired page breaks, but causes the sequencing of records to be alphabetical by category, which we don't want.
First time in the forum...will be grateful for any sugguestions: there must be a work-around that I'm not recognizing.