If I recall correctly, the filter expression must exaclty match the index key. ie, having employee.filetype might make it not optimizable if the key of the index is (as it should be) filetype. Is the index expression just exactly the fieldname, or is it upper(filetype)? If it is upper(filetype) then your where clause should be upper(filetype) = "EMPLOYEE"
That's all I can think of off the top of my head :)
>
>SELECT * FROM data\Employee.dbf WHERE Employee.filetype = "EMPLOYEE"
>
>
>Regards, Renoir
--Todd Sherman
-Wake Up! Smell the Coffee!