>>>>How do I make an INDEX ORDER SET with my VIEW table?
>>>>I want my VIEW table to have TAGS.
>>>
>>>After you have opened the view, select the view, then issue the FoxPro command for indexing.
>>>
>>>EXAMPLE
>>>SELECT eid, firstname, lastname ;
>>> FROM employee ;
>>> GROUP BY eid ;
>>> INTO CURSOR employ
>>>
>>>SELECT employ
>>>INDEX ON eid TAG eid
>>
>>Hi Monte..
>>I guess I over looked the obvious... that works and thanks alot...
>>another question...
>>Is the INDEX ON done in memory?
>
>The index created is a temporary file like the view itself. When you create an index on the view a temporary .cdx file is created with the same name as the temporary view file. If you want to see what the name of the temporary file is browse the file and from the Table menu choose Properties - The path and file name area at the bottom of the window. The index file name is the same name as the view with a .CDX extension.
>EXAMPLE:
>d:\temp\19152704.TMP is the file name of the view
>d:\temp\19152704.CDX is the name of the CDX

thanks for tip....