Frankly, I don't see how you may get so different time results.
However, I believe that you could change data design by having separate 'class' table. This way you ensure query minimum time and provide reliable interface to users.
>The sample data has 4 different classes, but there could be a lot more. At this point, I haven't been told or shown any "real" data to see. I would assume they can add whatever they want to the "class" field. All I was told was 'valid classes or "PSE", "EPH", "PPA", or "NPSE".'
>
>Let's assume about 20.
>
>>How many records do you expect to be selected from the table?
>>
>>>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.
>>>>>>
Edward Pikman
Independent Consultant