I'm looking for a suggestion to resolve a sorting dilemma.
I have a found set that is sorted based on a "status" field. Lets say that there are 3 possible values, "Level 1", "Level 2" and "Level 3". When viewing the found set sorted in List view, all is fine. In my solution, people access a different layout to look at a more detailed view, keeping the same found sorted set.
When they change the value in the Status field, lets say from "Level 1" to "Level 3", that record jumps in the sort order. I understand why FM does this, but it is a problem for me because people want to be able to go to the next expected record while on the detail layout, and when they change the Status value, they are moved to an unexpected place in the record order.
It seems that I need to create a temp sort order once they navigate to the detail view, that would replace the current sort order by "status". However multiple people may be looking at the same set of records and changing it for one person, may yield suprise's for others.
Suggestions are welcome.