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

Thanks! I will check it out on Monday morning at work and see how it goes!