Sorting and navigating related records

[AndrewBruno]

A parent file shows a portal. I want a script in the portal line that finds related child records ( easy enough with Go To Related Records ), but I want this set of records to be sorted in the same way as in the portal and the current record to be the one that was clicked in the portal.

I get the found set OK but only in creation order. If I do a subsequent sort, I end up in the first record, not the one that triggered the script.

This would be useful as I often want to scroll though records in a defined order but starting at a predetermined point.

Thanks in anticipation,

Andrew Bruno

[LiveOak]

Create another relationship based upon a global field in you main file. When you initially click on a record to select it, capture its recordID (or whatever you use for the portal relationship in the related file) in the global. After you setup the proper found set and sort it in the related file, use this new relationship with a Go to Related Record() script step without the "Show only related records" option.

-bd