Inserting a record into database in the middle not end?
I was wondering if there is a way of inserting a record not at the end of my database, but in the middle somehow?
I have my database sorted by record number which matches up to an inventory number I have assigned, so record number 1 is inventory number 1, etc.
A record was mistakenly deleted in the middle of my database which has made all the subsequent records out of synch.
Is there a way to re-insert this record in it's original place in the record order without changing the way records are sorted? It's important to keep my inventory number in synch with my record numbers.