You can use a parameterized view to speed up the process. There is an example on my website under Q&A, Forms, qFRM002

>I have more than 10,000 recs in my table. I would like to creat
>form that have one textbox and one grid which grid condition depend
>on textbox.valid (eg. My table is "Customer". Usually, in my
>textbox.valid :
> Sele Customer
> Set filter to state=This.value **********
> mygrid.refresh
> For this method, It take so long time. Please suggestion me
>for other method which I can reduce time.