SELECT DISTINCT MAX(FileSeqNo), FileDoctor, fileYrMth ; FROM ohDisk ; && found here <------------------------ WHERE FileYrMth = .cThisDiskYr + .cThisDiskMth AND FileGroup = "0000" ; AND FileDoctor IN ( SELECT DISTINCT exDoctor FROM ForOhip WHERE NOT EMPTY(exiniPK) ) ; ORDER BY FileDoctor ; GROUP BY FileDoctor, FileYrMth ; INTO ARRAY aDocsToBeCopied IF _Tally > 0 SELECT ohDisk && just for debugging...found here <----------------- FOR m.xx = 1 TO ALEN(aDocsToBeCopied, 1) USE (m.StoreDir + "\" + aDocsToBeCopied[m.xx, cDocYrMth] + aDocsToBeCopied[m.xx, cDocID] ; + PADL(ALLTRIM(STR(aDocsToBeCopied[m.xx, cDocSeq], 3, 0)), 3, '0') + ".dbf") ALIAS ToAppendTo SELECT ToAppendTo APPEND FROM DBF("ForOHIP") FOR exDoctor = aDocsToBeCopied[m.xx, cDocID] SELECT ForOhip COUNT TO m.yy FOR exDoctor = aDocsToBeCopied[m.xx, cDocID] AND OHIPclmRec = "HET" SELECT ohDisk && Get alias not found here <========================= LOCATE FOR FileYrMth = aDocsToBeCopied[m.xx, cDocYrMth] AND FileGroup = "0000" ; AND FileDoctor = aDocsToBeCopied[m.xx, cDocID] AND FileSeqNo = aDocsToBeCopied[m.xx, cDocSeq] IF FOUND("ohDisk") REPLACE IN ohDisk ItemsClmd WITH ItemsClmd + m.yy ELSE WAIT WINDOW "Control file record not found for " + aDocsToBeCopied[m.xx, cDocYrMth] ; + aDocsToBeCopied[m.xx, cDocID] + ALLTRIM(VAL(aDocsToBeCopied[m.xx, cDocSeq])) USE IN ToAppendTo ENDIF NEXT m.xx ELSE ENDIFAny idea what's causing the problem?