>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
Apart from the problems mentioned by Tore, there are at least two other problems with inserting a record in a certain physical position (with INSERT):
This is very slow in large tables.
This doesn't work with shared tables, in a multi-user environment.
You should control the position of the records with an index, on a field that contains the value on which you want to order.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)