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.