>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
You should never depend on the record number, that is against all rules. In stead you should have a special field to keep track of the order. If you later want to upsize to for example SQL server, which does not have record numbers at all, you will have to make a lot of redesign if you depend on record numbers.