Aaargh! Portal sort not working!

[aswi]

Hi,

I'm trying to get a dynamic portal sort to work and it just won't. I've got a global field in table A and a calc field in the table B. THe global holds the name of the field I want to sort on. The calc is a case statement that calcs the field on which to be storted based on the contents of the global field. I've made sure that all the case statements result in text. THe portal is sorted on the calc field. I have buttons set up outside the portal that set the global field using the Set Field script step. But the portal is just not sorting right. It will change the calc field all the time, but it won't sort by it. WHy is that? If I go in and manually change the sorting variable in the portal or add a sort to the realtionship, then it will update and sort by the field that's on the global field, but only once. If I change it, it won't update again until I go in and manually deleted and reinsert the sort variable. THis is very frustrating. Any ideas? Can it have to do with the fact that the relationship is an all-to-all (x)? It shouldn't matter though, should it? THanks.

[comment]

I don't understand your description too well, but it sounds like you need a Refresh Window [Flush cached join results] step after changing the global 'sort-by ...' value.

Note that dynamic sorting of portals by calculation is now obsolete, with tab control available - see:

http://www.fmforums.com/forum/showtopic.php?tid/186468/

[aswi]

Thanks!

Both answers have helped me tremedously.