Fred,

On the second line I had a comment to verify the syntax. I don't have VFP and I haven't used it from September, so I had to rely on my memory when writting commands.

Anyway, here it is

http://msdn.microsoft.com/en-us/library/h54fa37c(VS.80).aspx

So the second line should have been

insert into myNewTable from name loRecord

(BTW, it is not clear from documentation what will happen with Memo fields - are they included by default in INSERT Into)?

>I delivered the password update and we found out the transfer button does not work the code I used to transfer only current selected record is
>

>
>scatter name loRecord memo
>insert from loRecord into myNewTable &&(verify this syntax,)
>delete from myOldTable where ID = loRecord.ID
>
>

>
>Apparently line 2 has an unrecognized phrase or keyword.
>
>Any ideas where I might start all I have done to the code was change the table names
>
>Thanks a lot!!!
>
>Sincerely,
>
>Fred W.