>* 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.
If it's not broken, fix it until it is.
My Blog