This is what I am doing. Am I doing it the wrong way?

USE DBF("clpack") IN 0 AGAIN ALIAS canother
select canother

*append record to clpack if the student is new
if new.newstud = .T.
append blank
REPLACE canother.materialid with "VX58"
REPLACE canother.description with "Study Skills Manual"
endif