Dovi --- Could you restate the problem a bit more legibly and without caps? Hard to tell what you're trying to do.

>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