Steve;

Are you on a network? How many records in the file? Do you have seperate CDX tags for custID and poNum? Your first Select statement should run quickly with the two required index tags.

select * from pastinvoices as pinv where pinv.custID = "149" and ;
pinv.poNum = "143619" into cursor cp


Have you tried sys(3054) to see Rushmore optimization?

Questions, questions always questions.

Tom