By default, it gives the first TRANS-IDENT in the one-to-many relationship.
File=CBCHECK
Field=TRANS-IDENT
What would be the most efficient way to get the last TRANS-IDENT for a check? I really don't want to read through an entire query just to get to the last one. SORTDESC seems to only sort the portion that is being retrieved and would have to get to the last NEXTCALL anyway.
Is there a way to position to the end of the file and read one record backwards? Is there a way to sort the index in reverse order instead of just the page returned?