creaTE CURS IREPO (tablename c(25), field_Name c(25), flag L) sele 0 1. Collect all table names with adir(aa) 2. for ia =1 to alen(aa,1) use (aa[ia,1]) release afld =afield(afld) m.flag=ascan(afld,"FIELD_NAME_YOU_ARE_LOOKING_FOR")>0 for ib=1 to alen(afld,1) insert into irepo values (aa[ia,1],afld[ib,1],m.flag) endif endfor index on tablename+field_name tag hello>VFP 7 (8 latter)