>>Hi all, i just need to create a index to show by client the invoices but keeping for each client their invoices in descending order, from the newest to the oldest. This index must be created on the table structure. Any ideas.?
>>
>>Thanks,
>
>If it is for a report, I wouldn't create an index at all.
>
>

>select [fieldlist] from [table];
>  order by Field1 asc, Field2 desc;
>  where [some condition];
>  into cursor Tmp
>report form ...
>

I agree wholeheartedly. One of the "good database design" rules is never to create a compound index for a single purpose, unless there are no alternatives. In this case, an index on each of the relevent fields will make your query fully optimized, and thus extremely fast. Maintaining a compound index, on the other hand, will make the table update slowly, and for "nothing".