Sorting problem

[freecolours]

Aahhh ... what's going on in FM 7? I have a portal with a number of records, sorted by a sort number in a separate number field. When I deselect the portal, the sorting doesn't work anymore...

I use this portal for navigation, so the sorting must be accurate ...

Anyone any ideas?

[TerenceM]

It might help if you post an example. One thought is that you might have two different sorts specified for the portal. One specified for the relationship itself (in Define Relationships), and the other for the portal as defined on the layout. Just a guess.

-Terence

[transpower]

What version of 7 do you have? Your problem may have been corrected in 7.02 or 7.03.

[freecolours]

One thought is that you might have two different sorts specified for the portal. One specified for the relationship itself (in Define Relationships), and the other for the portal as defined on the layout. Just a guess.

-Terence

Terence, thanks for thinking along, but no, I tried multiple definitions too. Like a sort from only the relationship and only the one on the layout, AND both the same sort, but nothing did work out well...

[freecolours]

What version of 7 do you have? Your problem may have been corrected in 7.02 or 7.03.

I use(d) Filemaker Developer 7.0v3 for this case. But I decided to stay in FM 6 for this solution, because I experienced too much problems with valuelists and portal functions. Migration to FM 7 is sometimes not the best option....

But I do have another sorting question.... do you know a way for sorting a portal via a script? For ex. I have in a portal 3 fields; name, zip, city.

What I would like to do is sort the portal by one of these by a button on the layout where the portal is placed... Is this possible? (I do see the option 'Custom order based on value list, but how to do that?)

[freecolours]

Found it out allready ... I used a global text field (_gSortGlobal) in the related database and a calculationfield (_cSort) like this:

Case(_gSortglobal = "name" ; Name ;

_gSortglobal = "zip" ; zip ;

_gSortglobal = "city" ; city ;

"")

I use the _cSort field to sort the records. Hope this could help anybody who had the same issue ...

[-Queue-]

You could also use GetField(_gSortglobal), if your field names match the value of _gSortglobal. It is case-insensitive, so both name and Name should work, etc.

[TerenceM]

So does your original sorting problem not happen in FP6?

-Terence