Portal Sorting driving me crazy!!!!!

[Brewser]

I have a portal setup for a card collectors DB. I have it setup with different colors to reflect the different options the user has to pick from such as 'own', 'trade', & 'sold'.

When the user selects a new record for the portal I want the new record to be first in the portal.

I want the sort to be 'own' first, 'trade' second, and 'sold' third as they are listed in the portal. The 'own', trade',& 'sold' are listed on the form as checkboxes, so they either have a value of '1' or '0, zero'. I have tried setting up the order through sort portals, but it never comes out right. Is there something else that would setup the portal to list the cards in this order? Another note is that when a card is selected as 'own' it can also have a check for 'trade' since the user may want to trade this card.

I thought I could setup the portal order as 'own', 'trade', & 'sold', but I get mixed results when FM lists the order.

thanks,

Brewser

[David Holmberg]

Could you attach your file so that we can see what you have acccomplished so far.

I'm on a lecture right now ( a little bit unfocused) but my first reaction is that you're doing the right thing.

[Ugo DI LUCA]

Hi,

Try converting these 3 options to one calculation.with a result of 1,2 or 3 depending on your 3 choice results (1 for own, 2 for trade and 3 for sold). Then use this calc as the sort key of your relationship.

[Brewser]

Hello,

Thanks for the info. Right now I just have the fields setup as checkboxes with 1 or 0 as the value. Would you create a global field with with a case formula to do the sort?

[Ugo DI LUCA]

Hi again,

Choose(own;Choose(trade;3;Choose(sold;1;3)))

or

If(not IsEmpty(own and sold and trade);Case(own;1;trade;2;sold;3);0)

[Brewser]

I guess I answered my questions in the last post. Thanks for your help. This works great.

[Ugo DI LUCA]

A funky one...

Position(own&trade&sold;1;1;1)