>You should make sure that all indexes for a table are stored with the table in a compound index file (cdx).
>
>Can you post the SQL that defines your view?



This is it, generated by VFP


SELECT Pyoutbak.int06, Pyoutbak.c40_01, Tlkppaf.name, Pyoutbak.date01,;
Pyoutbak.datm06;
FROM sys2core!pyoutbak LEFT OUTER JOIN sys2core!tlkppaf ;
ON Pyoutbak.int01 = Tlkppaf.int01;
WHERE Pyoutbak.int06 <> 0;
AND TTOD(Pyoutbak.datm06) >= ?gd_start;
AND TTOD(Pyoutbak.datm06) <= ?gd_end;
ORDER BY Pyoutbak.datm06

VFP created the index on the root_ directory of the server if that means anything.


CG