>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.

>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.

Tamar