You may need to USE the table again with a new alias before being allowed to index on fields. Ir the nofilter clause might help.
>ARGH!! I'm having troubles here, I've got a search form, which has fields at the top to search on...the grid shows the results, which now I've got it set to RECORDSOURCETYPE=1-ALIAS, and all is well as far as showing the results, but I want to allow my users to click on a header and sort by that column...preferably without requerying the SELECT statement with the ORDER BY. But when I try to
>
INDEX field TAG field
>INDEX field TAG field additive
>VFP gives me an error that a .tmp file is read-only...
>
>Is there a way to have more than one index on a cursor?
>Is there a better way I should be doing this???
>
>HEEEELP MEEE!!!! [:o
--Todd Sherman
-Wake Up! Smell the Coffee!