Using just append you can't do it. Create an index is the best solution.
In the worst case try this (Only if necesary .This is a bad solutions for long databases)
P.e If you decide insert a new record in the third pos.
m.field1="value1"
m.field1="value2"
Select * from mytable into table tmp1 where recno()>3 && Get the last records
Select mytable
Delete all for recno()>3 && delete the records in the temporay table
insert into tmp from memvar
Append from tmp1
Juan C.
"Anyone who has never made a mistake has never tried anything new." A.E
"The important thing is not to stop questioning. Curiosity has its own reason for existing." A.E