>Now there are around 15000 records is customer master. Customer Master is having 56 fields. Now we want to filter out certain customer who are marked by a field call TV_OUT or CTA_OUT. So if any of these fields are not empty then this customer should not be displayed in the help listbox. We have used listbox wizard to have custno and name from customer master into listbox.
>
>We are using free tables in our project. If we filter the customer table then listbox display will be very late after we click help button.
>
>How can we make it fast ? Pl. Help
How many records actually get displayed in the list box once the filtering takes place? (Incidentally, I agree with Cetin that SQL should be used instead of filtering). VFP list boxes tend to be slow to begin with and become slower and less predictable past about 50 entries or so. If you are passing that limitation, you might want to consider using something more robust, like dbi Technologies toolkit, as an example.