I have a table with lots of record, I want to insert one record at the top of it (as recno #1), the old fashion way is to copy all the records to temporer table, zap it, insert the record, re-append from the temporer table.

but I think it should be another easier way.

please advise

thanks for the help

regards,

Jerry