>DOES ANYBODY KNOW HOW TO COPY PERSAY FIELD1 FROM MYTABLE TO FIELD 1 TO MYTABLE_2 AND ALL ITS RECODS....BUT AT THE BOTOM MENAING IF FILED 2 HAD 300 RECORDS AND I COPY 300 RECORDS FORM FIELD 1 OF MY TABLE, NOW I WILL HAVE 600 RECORDS....
>THANK YOU

If table1 and table2 have all the same fields you could use APPEND FROM. Look up the syntax in VFP help.