>* The Id is the record you want. Note that you may get incorrect results if you use record numbers.
>

SELECT * FROM tierii_chem WHERE Id = 1424 INTO CURSOR crsTemp
>SELECT <tabletoappendto>
>APPEND FROM DBF("crsTemp")

>
>I am trying this method, and it appears to perform some sort of operation. However, there are no new entries at the end of my table.

insert into TableToAppend select * from Tierri_chem where ID = 1424

In your first case there is a possibility the original table got filtered.