Yes. Indexed on "class", name of index is class.

>Very good. Now about the cursor. Do you have a tag in the table on class?
>
>>Yeah, I've read that somewhere. I will check into my 1001 Things Book about this.
>>
>>Thanks
>>
>>>Regardless to cursor creating problem it should be much faster to use grid instead of list or combobox.
>>>
>>>>>>Hi Gang!
>>>>>>
>>>>>>One last question today.
>>>>>>
>>>>>>In setting up a form for some reports, there is a field called CLASS in a table PSE_drug
>>>>>>
>>>>>>I have an index set on class which is simply CLASS.
>>>>>>
>>>>>>Now, when I open the PSE_drug table and issue the command
>>>>>>
>>>>>>SELECT DISTINCT class FROM PSE_drug INTO CURSOR class
>>>>>>
>>>>>>it takes less than a second to get the cursor from a table of 5 MILLION records!
>>>>>>
>>>>>
>>>>>Try issuing DBF("class"). I'll bet you're filtering the original table.
>>>>
>>>>When I start over (close VFP and restart VFP) and issue the SELECT, it took 0.91 secs.
>>>>
>>>>Then I issued the ? DBF('class') command and got
>>>>
>>>>c:\docume~1\tommy\locals~1\temp\04IC002D.tmp
>>>>
>>>>So, this means it is an actual cursor, correct?
>>>>
>>>>>
>>>>>>Yet, when I set this up as the ROWSOURCE with ROWSOURCE TYPE = 3 (SQL STATEMENT), it immediately turns into a dog and takes about 70 seconds to populate the control... sigh.
>>>>>
>>>>>Here, you're probably building an actual cursor.
>>>>
>>>>After running the program, and getting out and going back and running the SELECT manually again, it took about 10 seconds to get the class cursor.
>>>>
>>>>And the DBF('class') was c:\docume~1\tommy\locals~1\temp\04IC008M.tmp this time.
>>>>
>>>>Maybe the program's settings is changing the environment detrimentally as compared to when I intially run the query by hand when I first start up VFP??.......
>>>>
>>>>Thanks!
>>>>
>>>>>
>>>>>Tamar