Sometimes when I need complex dynamic sorts I use a PRIV table and link it
to the main table, so the PRIV table is the master.

The PRIV table has the key values and a sort column (LongInt). Then a secondary
index that is that sort column as primary.

I code filling that longint column in any sort order I need, by queries and
sorts, then scan the sorted results filling into the sort 1...to end on the
PRIV table master.

There are several variations for this.


Peter <peterspammenot@whiteknight.email> wrote:
>display of records
>
>On 12/08/2023 09:04 p.m., Tom Krieg wrote:
>> That's correct. Is this for display? Or something convoluted and 
>> illogical? Have you tried extracting and sorting?
>> 
>> On 9/12/2023 1:47 pm, Peter wrote:
>>> Oops, I was not clear, I need both ascending and descending in the 
>>> same index. The Index method will not allow for mixing ascending and

>>> descending.
>>>