Jim,

>>When all you want to do is poping up a maintainance form for unfiltered main tables (Articles, clients, employees) where the default is non-filtered you don't want a delay of a few seconds. The form should pop-up inmediately.
>
>I design for scalability and Client/Server access. I never pop up a maintenance form with a full recordset loaded. In my forms, the user specifies what they want and then I get that for them.

That's the difference, I don't design for scalability for C/S system if I suspect that the system will never be upsized to a C/S environment, giving me more flexibility at the UI side.

My users can freely browse through the tabel and I provide some powerfull search mechanisms to find the data the user needs. Filtering tables is one of them.

Walter,