I have a portal in Companies that shows all related Contact. In the Contact file I have checkboxes for MAIN, SPECIALS, PRICING... I would like to have the portal in Company file sort these on the value list for the checkboxes (MAIN, SPECIALS, PRICING). This works fine when 1 checkbox is selected but as soon as the Main Contact also receives specials the person goes to the end of the list.

Does anyone know how i can fix this?

Make sure the checkbox field is defined as Text?

It is a Textfield.

I don't have version 6, and I am unable to reproduce your issue in either 8 or 4. Perhaps you should post a small sample demonstrating the problem.

Here is a screen shot of the portal. I am sorting by value list

Main

Specials

Pricing

I thought that if the field contained "MAIN PRICING" it would sort those with the Mains at the top of the list, but they go straight to the bottom?

Listsample.pdf

I am sorting by value list

Ah. That's something new. I can't say for sure, but I am guessing "Main¶Pricing" is not considered a member of your value list - therefore it is listed AFTER all the values that ARE included in the list. At least that's how it behaves in version 4.

Version 7 and higher conforms to your expectations, and will place "Main¶Pricing" among the "Main" records - but it will NOT sort the group internally.