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.
>>>>>
Tommy Tillman A+ NetWork+ MCP