... SELECT DISTINCT P.pj_pcode,P.pj_title,P.pj_state,P.pj_id ; FROM DD_Proj P, DD_Tasklist T, DD_Tskdwgs D ; WHERE P.pj_state='A' ; AND P.pj_id = T.tl_projid ; AND T.tl_id = D.td_tlid ; AND D.td_code = ALLTRIM(STR(INT(VAL(Thisform.cboWc.Value)))) ; ORDER BY P.pj_pcode ; INTO CURSOR ProjListNew ...