creat table hold_qpr (Tofind m) if NOT USED('hold_qpr') use hold_qpr in 0 ENDIF select hold_QPR append blank replace hold_qpr.tofind with 'queryid from findhere where findhere.queryid="4" into table yippy' CREATE TABLE findhere (queryID c(6)) if not USED('findhere') use findhere in 0 ENDIF select findhere for i =1 to 30 insert into findhere (queryID) values(alltrim(str(i))) endfor holdfield='hold_qpr.Tofind' runqpr=&holdfield select &runqpr if not used('yippy') use yippy in 0 endif select yippy browI am sure there are otherway's for doing the above, but it works for me, so iam happy chappy Yipppyyy!!!!!.