>Is there another way to index a table with
>using INDEX ON my_fld TO inx_name?
>
>I want to ORDER BY a group of records
>that are contained in a filter using SET FILTER TO something.
>I do not want to use INDEX TO or the SELECT statement.
>Any ideas?
What are you trying to acheive with the index? To optimize the filter, or to order the records?
If you want to order records by a number of fields, simply add them together in the index :-
INDEX ON Field1+Field2+Field3 TAG tagname
(Remember to convert numbers and dates to character values).
If you want to optimise the query, then create a seperate index tag for each field and Rushmore will do the rest.