thanks for that, i got that to work but that replaces all the fields in the new table, what i need it to do is add new fields to the end of the table.
is it possible to use variables and read data into them so i can validate it, and then insert it to the new table? if so how?
cheers again