Problem Part the 1st: I would like to present a user with a context portal which contains 19 lines. The center line (#10) will be occupied by the current record, the 1st 9 lines would be occupied by the 9 records which precede the current record in the current found set, and the last 9 lines would be occupied by the 9 records which follow the current record in the current found set.
It seems to me that this could best be accomplished by having a calculation called "Context Plug" (= "Get ( RecordNumber )") and pointing it at another calculation called "Context Socket", calculated thus: Get ( RecordNumber ) - 9 & "¶" & Get ( RecordNumber ) - 8 & "¶" & Get ( RecordNumber ) - 7 & "¶" & Get ( RecordNumber ) - 6 & "¶" & Get ( RecordNumber ) - 5 & "¶" & Get ( RecordNumber ) - 4 & "¶" & Get ( RecordNumber ) - 3 & "¶" & Get ( RecordNumber ) - 2 & "¶" & Get ( RecordNumber ) - 1 & "¶" & Get ( RecordNumber ) - 0 & "¶" & Get ( RecordNumber ) + 1 & "¶" & Get ( RecordNumber ) + 2 & "¶" & Get ( RecordNumber ) + 3 & "¶" & Get ( RecordNumber ) + 4 & "¶" & Get ( RecordNumber ) + 5 & "¶" & Get ( RecordNumber ) + 6 & "¶" & Get ( RecordNumber ) + 7 & "¶" & Get ( RecordNumber ) + 8 & "¶" & Get ( RecordNumber ) + 9 The problem is that I can't require either of these calculation fields to be stored (or they freeze at some point in time, rather than shifting dynamically based on Find conditions and sort order), but I can't establish a relationship between them if they're not. Am I missing anything obvious here? Problem Part the 2nd: Assuming I'm looking at a record which contains a portal showing similar records, I would like the portal line featuring the record I'm currently looking at (known to FMP documentation as the "current record") to be highlighted. Unfortunately, it appears that every record thinks of ITSELF as the current record, whether it is or not at any particular time, and I'm unable to make the actual current record stand out in a crowd. (This points up the ambiguity in FMI's use of the term "current record".) Once again, does anyone have any tricks to make this happen?
