SELECT mytable GO TOP SCAN SELECT mynewtable APPEND BLANK REPLACE empno WITH mytable.empno FOR m.iii = 1 TO 5 m.target = [tax]+STR(iii,1) REPLACE (m.target) WITH mytable.taxamt IN mynewtable SKIP IN mytable NEXT SKIP -1 IN mytable ENDSCAN>Hi all,
>Select 0 >Use mytable Exclusive >Copy Structure To mynewtable > >Select 0 >Use mynewtable Exclusive > >Alter Table mynewtable Add Column tax1 N(5) >Alter Table mynewtable Add Column tax2 N(5) >Alter Table mynewtable Add Column tax3 N(5) >Alter Table mynewtable Add Column tax4 N(5) >Alter Table mynewtable Add Column tax5 N(5) > >** from here I would like to get to insert an empno 11111 and 5 new taxes in mynewtable.dbf in first row >**and an empno 22222 and 5 new taxes in mynewtable.dbf in second row and so on.... > >>