Hi!

The best way is to use the query with ORDER BY and joined lookup table, or select fields from all joined lookups and index the result set (you can do this also as a view). Indexing on another tabe is not a good idea and also is dangerous because such indexes often got corrupted and you will not be able to open main table without opening of all other lookup tables.

In addition, you can use the INDEX command on the fly for that table and create temporary non-compound indexes in the external temporary CDX file:

INDEX ON ... TAG tmpTagName FILE tmpCDX

However, BEGIN TRANSACTION does not like such indexes...

HTH.

>Has anyone got a good solution for how best to order by a lookup table? Has someone written an article addressing this that I can read?
>
>I have the situation where my main table has 6 lookup tables any of which the user may wish to order by.
>
>I was always under the impression that you shouldn't create an index that ordered by a field in another table is this true - if so what is the best way of overcoming the above.
>
>Thanks in advance.