You are right, there is no way a user can remember all items in a pick-list. But i have installations where the company has over than 400k customers... Should i try to fit 400k customers in a pick list... I use pick lists for very small set of data ( 5-10 records ) greater than that, it becomes useless. So what's the solution: search. Asking for criterias from the users and presenting them with a narrowed down list of 10-20 items. They can then pick and repeat...

Stephane

>I've read that, but honestly, I don't get how you can do that. When the user clicks on the customer picklist button, they expect to see all of the customers, not just some of them. I have no idea what customer they're going to choose, so how can I possibly guess at a subset? And if I knew which one they wanted, there wouldn't be much point of a picklist. I guess I must be missing something. Or don't anyone else's users need to choose from a list? I know mine don't memorize every record in every lookup table. LOL!
>
>Thanks,
>
>Michelle
>
>----------------------------------------------------------------------------------------
>
>>One of the most important thing in n-tier programming is that your business object should only return small amount of data. Try to do all your processing in the business logic and then the speed wont be a factor back to your form.
>>
>>ADO can handle large amount of data but again you should always keep your resultsets to a minimum size.
>>
>>Stephane