I want go to the record where I left to perform find and sort, is there any simple way?
Add a global field to the table. In your relationship graph, duplicate the table occurrence and link its primary key to the global field in the original table occurrence.
Your script can then set the global field to the current Record’s primary key, perform the Find/sort, then use Go To Related Record without selecting “show only related...” to put the focus back on the original record.
Not sure that I follow that. Do you mean that you are on record X, you perform a Find/sort and you want to still be on that record if it’s part of the new found set?
Or do you want to find records, work with them and then return to the same record?
both are possible. The latter can best be done by opening a new window and performing the Find in the new window. When finished, close the window and you are back on original record.
Yes, how to deal with the first one?
Retrieving data ...