<<1. How long is "so much time"?>>
About 5 seconds.


<<2. Could you give us an outline of your environment - type of network (if any), speed of workstations, OSs, etc.>>
I am testing it on my hard drive alone which has the following specs:
Pentium II 400mhz
64 MB RAM
Win 98
<<3. Could you post some samples of requery code/view definitions etc.>>
SELECT TOP 1 Itm_pk, Itm_cbcdck, Itm_dissue, Itm_cistyp, Itm_nwshct, ;
Itm_nstnct, Itm_nrprct, Itm_cltcod,Itm_dltcod, Itm_clship,;
Itm_dlpcku, Itm_qctfk, Accounts.acc_cusfk, Accounts.acc_ccodck,;
Accounts.acc_croute, Accounts.acc_cday, Accounts.acc_cdlvry,;
Accounts.acc_dinst, Accounts.acc_cstat, Accounts.acc_cdtran,;
Accounts.acc_l1scan, ;
padr(nvl(Qcinspreq.qir_cusfk, ''), 6) as qir_cusfk, ;
padr(nvl(Qcinspreq.qir_accfk, ''), 6) as qir_accfk, ;
nvl(Qcinspreq.qir_lrush, .F.) as qir_lrush, ;
padr(nvl(Qcinspreq.qir_qcmfk, ''),3) as qir_qcmfk, ;
nvl(Qcinspreq.qir_ncode, 0) as qir_ncode, ;
padr(nvl(Qcinspreq.qir_mnotes,''),4) as qir_mnotes,;
padr(nvl(Qccertmethods.qcm_ccodck, ''),10) as qcm_ccodck,;
padr(nvl(Qccertmethods.qcm_cdescr, ''),20) as qcm_cdescr,;
nvl(Qccertmethods.qcm_nfiber, 0) as qcm_nfiber,;
padr(nvl(Services.Svc_ccode, ''), 3) as Svc_ccode;
FROM gt!ITMMASTER ;
LEFT OUTER JOIN gt!Accounts;
ON ITMMASTER.itm_accfk = Accounts.acc_pk;
LEFT OUTER JOIN gt!Services;
ON ITMMASTER.itm_svcfk = Services.svc_pk;
LEFT OUTER JOIN gt!QCInspreq;
ON ((Qcinspreq.qir_cusfk = Accounts.acc_cusfk AND ;
Qcinspreq.qir_accfk = Accounts.acc_pk) OR ;
(Qcinspreq.qir_cusfk = Accounts.acc_cusfk AND ;
EMPTY(QCINSPREQ.QIR_ACCFK))) ;
LEFT OUTER JOIN gt!QCCertMethods ;
ON Qccertmethods.qcm_pk = Qcinspreq.qir_qcmfk ;
WHERE ITMMASTER.itm_cbcdck = ?lcItm_cbcdck;
ORDER BY Qcinspreq.qir_accfk DESC


<
- are you using parameterized views?>>
Yes

<<- sometimes, when using frameworks, you can place code in the wrong method, and then your code gets executed multiple times for each form refresh. Perhaps you could put a strategic WAIT WINDOW in your requery code to see if this is the case.>>
The textbox has a 'customvalid' meethod and that is where I put it.

By the way about 4 seconds is what it takes to execute the SQL statement by itself outside of the form. If the SQL statement is plain vanila: less fields, no calculated fields, no joins, the process still takes about the same. I have an index tag on ITMMASTER.itm_cbcdck for the WHERE clause above. What am I missing?

I have more tables that are bigger than that one and I am starting to worry about the system performance.

Thanks for more help.

Evelyn