>I give the option of displaying all patient names (approx 1500) in our database as a last resort to users. I tell them that this is the slowest method of searching for a patient. It takes about 3 seconds to display the entire list of names in a list control.
>
>The select is very simple:
>SELECT unique_id, patname from demogrph into cursor cAllPats
>
>This query takes about 3 seconds even though I have indexed on the field "patname". Doing a query that returns the complete results from a table seems redundant. How can I display (into a grid or list control) the fields from the table directly and thus decrease the 3 second query time to almost instantaneous?
>
>A BROWSE is quite efficient, can I harness this? It can display the fields I want (ordered too) almost instaneously.

You can use table itself as grid.recordsource