Finding specific record in portal

[DBUSER]

I have an address database with a related phone table. The phone table has multiple records. One of the fields is called primary. It is a yes/no field with only one designated with a yes for any particular related record or person in the address database. Of all the phone numbers, only one is primary.

 

When I perform a find [Phone_Table::Primary_Phone;"Yes"] the portal only brings back the first record in the list, even if the primary is the 2nd or 3rd+ record. It recognizes the fact that one number does have a "Yes" in the primary field. What do I need to do to get the specific record with the appropriate phone number for primary displayed?

[LingoJango]

Sort the portal by the Yes field first, reverse sort order.

[DBUSER]

Thanks. I figured out the Yes and sort option myself. While that works to find the specific record for Primary_Phone = Yes, I ran into a more difficult issue if I wanted to find just the work phone or home phone, etc. My final solution was to create a calculated field that could handle multiple options and reverse sort so that the one I really wanted was always at the top.

 

If(ADDRESS_DATA::Select_Type="Primary";If(Primary_Phone="Yes";1;0);If(Phone_Type=ADDRESS_DATA::Select_Type;1;0))

 

On another note. I wasn't sure if the sort was working at first. Turns out I had to Refresh Window [Flush cached join results] when I made a change in the portal data to see the real time impact when checking if the solution was working.