You could try to put Show All Records BEFORE Create a New Record.
Is your record set sorted?
The sort order generally persists in list view, even resorting forllowing the creation of new records, which causes a shift in its position in the list.
My understanding is that FM's default behaviour if you perform a Show All is to go to the first record. If you want to land on a specific record after Show All you have to script that (eg. capture the record ID as a variable, Show All then go to record by calc)
Not sorted, and I also keep testing the issue. It does seem to me, only happend FM Go.
Only when foundset is empty, ShowAll will bring the record position to the first by default.
I found the fix.
// My records status is 1/200, just created a new one among in total of 200 records.
Commit the record <----Add
Show All Records
Before "New Record", the foundset is empty.
Empty foundset leads to landing to the first record after "ShowAll".
Commit the record, is to "ensure" the new record existance in foundset.
can not explain the same thing to Filemaker Pro advance.
Small correction to my previous post—Show all behaves differently depending on how it is activated. If you select Show All from the Records menu it will default to the first record. If you perform Show All within a script it will (a) remain on the currently active record if one is currently active, but (b) default to first record if the current found set is empty.