Do you see any difference in performance if you define a sort order on a relationship to this table so that you can just refer to the first related record instead of the last?
Also, a script that uses Go To Related record followed by Go to record/request/page/last could also access the data on this same "last" related record.
Thanks for the response Phil. Sorry it took so long to answer. Thank you for the idea. The sorting did not change anything, so moved on to scripts
I have created 2 scripts
1. I created a script that does a search that uses the master record id and then go to last created child record. I also have the date and hour the record was created so at that point i can sort as needed. At this time It seems to be working much faster.
2. I used your idea which is close to the script 1 above, but used Go To Related record then Go To last as you recomended. This script seems even faster than script 1.
Thanks again Phil.