I'm trying to sort portal records using a custom sort order based on a value list. The value list is actually in the same file as the portal records. However, the value list does not sort in the custom order as defined by the value list, but rather alphabetically.

The value list is rather long, but it worked in FM6 just fine.

I've tried:

sorting the portal records via the portal definition

sorting the records in the relationship definition

Both have the same effect

Any ideas?

Edited August 3, 200520 yr by Guest

the value list does not sort in the custom order as defined by the value list

Can you explain what you mean by that statement. Are there two different value lists involved?

Sorry, I meant the portal records do not sort, not the value list. My frustration must have overwhelmed my communications skills.

It works for me - can you post an example?