Always open at the same record
I have a database (yes, don't we all?) that always opens at the same record (of 2600+) with a find of one. No matter what I do, make a new record, close in many different states it always opens at the same record. I have worked around this by writing a script "show all" followed by "go to last' but it is bugging me.
I assumed a corrupt index but 'recovering' the file makes no difference. I can't delete that record as it has dependencies on an auto-entered ID field.