>I'll have to try that. Most of my lookups are in tables small enough that the difference should be invisible, or else in tables LARGE enough that an array is impossible because of the 65,000 element limit.
>
>However Ascan() has to look at all elements - my gut reaction would have been that it was slower than a Seek.
>
>Thanks for the information,
>Barbara
>
>
>>It appears to be that way to me. I don't have any empiricle (sp) tests, but that is my impression when I have done it. I may have to be with it being faster to read the elements than to actually read the fields from the table.
Part of that would be how much of the lookup really needs to be in memory. I usuall just grab two fields. That allows for lookups with up to 32000 records.
Cy Welch
Senior Programmer/Analyst
MetSYS Inc