Hi Gang!
I have a form which has a combobox that I want to populate from a field from a table called REGTRANS. The field is PTNT_NAME (C-30).
In the LOAD of the form, I have this code....
SELECT DISTINCT ptnt_name FROM regtrans WHERE DELETED() = .F. INTO CURSOR csr_names ORDER BY ptnt_name
I have an index in REGTRANS called DELETED which is indexed on DELETED().
The form has SET DELETED ON.
For the combobox, here are the DATA properties...
CONTROLSOURCE csr_names
ROWSOURCE csr_names.ptnt_name
ROWSOURCETYPE 2 - ALIAS
VALUE ""
When I bring up the form, the SELECT statement takes about 35 seconds to populate the combobox....
REGTRANS has 2,693,163 records and the SELECT statement pulls out 244,799 recods (for the combobox). When form comes up, the combobox works fine (very responsive and I can do the Incremental Search.
It just takes TOO DANG LONG to come up!!!
Does anyone see anything wrong in how I set this up (Rushmore????).
Thanks!
Tommy Tillman A+ NetWork+ MCP