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