SELECT TheSourceTable LOCATE TheRecordYouwant SCATTER MEMVAR MEMO INSERT INTO TheTargetTable FROM MEMVAR