I created a simple database with about 10 fields.
I entered an initial 1866 records into that database in order and each got assigned an autonumber.
These records are from a cemetery and are listed in row order left to right.
After completing the initial set of records, I have come upon some 50 records
of individuals who are buried at the cemetery, but have no head stone. Some of these people I know exactly where their record should be located in the sequence and others I do not.
Problem, I have this autonumber record number that so far has controlled the sequence. The new records would end up at the end of that autonumber sequence.
I know that I can delete that autonumber field but I have no other unique field currently to use to sort the records on after I delete that autonumber field.
I do have row number field which will help some, but not a grave number field.
But I can add one. Then do a two column sort I guess to reset the sequence.
Then recreate the autonumber after all the new entries are in place.
Question is, is there any other more simple way to plug these records into
their spots without going through the process I just described?
I also have a couple of records I missed on the original transcription that need to be plugged in.
The row-grave sequence is part of what makes this project unique. I do NOT want to change it to an Alphabetical sort. Yes I know that would simplify things.