Jeffrey,
Maybe this is a typo but shouldn't it be:

SELE pat_lname, pat_fname, pat_dob, pat_cdcid, recno() as cRec;
 FROM PATIENT_VIEW;
 WHERE ALLT(PATIENT_VIEW.PAT_LNAME) = ALLT(THISFORM.TXT_PATLNAME.VALUE);
 GROUP BY PAT_LNAME;
INTO CURSOR CURPAT

HTH

>i have set ansi off now. still pulling more records than it should. here's the sql statement
>
>SELE pat_lname, pat_fname, pat_dob, pat_cdcid, recno() as cRec FROM PATIENT_VIEW WHERE ALLT(PATIENTS.PAT_LNAME) = ALLT(THISFORM.TXT_PATLNAME.VALUE) GROUP BY PAT_LNAME INTO CURSOR CURPAT

>i have set ansi off now. still pulling more records than it should. here's the sql statement
>
>SELE pat_lname, pat_fname, pat_dob, pat_cdcid, recno() as cRec FROM PATIENT_VIEW WHERE ALLT(PATIENTS.PAT_LNAME) = ALLT(THISFORM.TXT_PATLNAME.VALUE) GROUP BY PAT_LNAME INTO CURSOR CURPAT