[log in to unmask]"
type="cite">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?