On 2011 Jan 21, at 18:42, Stephen Wonfor wrote:

> Richard
> 
> 1.  Could you not grab the SerialID of the record you are on, do a search for SerialID - 8 & "..." SerialID + 8, and write into a dummy field the values from -8, -7 ...0...6,7,8 and then have your portal sort by that ID#?

The problem isn't in SORTING the portal, the problem is in getting the portal to display the proper records in the 1st place. If I'm looking at, say, Record #110 in the current found set, I'd like the portal to show Records #101–119. And, when I stick a field in the portal asking it to display the value of "Get ( RecordNumber )" for that particular line, indeed it claims it IS giving me Records #101–119. But it isn't. It's giving me what USED to be Records #101–119 back at some prior state of the database, when it decided to freeze the RecordNumber values in place. Apparently it doesn't dynamically update the value of "Get ( RecordNumber )" as you change the found set or sort order. (Or at least it doesn't change the LINKED values. When I display "Get ( RecordNumber )" for the main record, outside the portal, it gets it exactly right.)


> 2.  If the serialID of the main record = serialID of the same record in the portal you can use conditional formatting to highlight it.


Well, I tried using a calculation that compared the main record's serial ID (called "DanSeq", short for "dance sequence number") to its equivalent within the portal. This is what I used:
   Case ( 
     DanSeq = Dance Picker::DanSeq; F::Yellow; 
     ""
   )
What I got was no highlight. Just to be sure, I tried the same comparison to produce a numeric result, and I got no hit for that, either.

I am frustrated.