Well, unfortunately there is no easy solution...
You can have a field called SeqOrder. Originally set it to be, say, recno()* 1000. (This will give you a gap of 1000 between records). You can now insert records with the SeqOrder you want and refresh a grid.
>Hi,
>
>To insert a record into a grid, between two records, I found it next to impossible. After many hours of work, I found that I had to delete all index tabs, then insert the record, and then re-create the indexes. This is very cumbersome, and dangerous.
>
>Any easier solutions, anyone ?
>
>Regards,
>
>Steve.
If it's not broken, fix it until it is.
My Blog