Here's a little problem I'm encountering, and I can't figure out a
way around it. Probably I'm just overlooking something obvious.
My problem is that every record thinks that IT is the current record
— or at least it behaves that way — and there seems to be no easy way
to check to find out if it really IS the current record.
To help make this problem statement easier to understand, I'm going
to introduce a new term: "This Record". Let me illustrate what I
mean. Here's a very brief set of records from the "Widget" database:
ID SKU Price x Qty = Cost
11 AAA $0.99 x 100 = $99
22 BBB $2.80 x 200 = $560
33 CCC $0.42 x 300 = $126
44 DDD $5.00 x 400 = $2000
So the AAA record "thinks" that the "This Record" value for Price is
$0.99, the BBB record "thinks" that the "This Record" value for Qty
is 200, the CCC record "thinks" that the "This Record" value for Cost
is $126, and (importantly) the DDD record "thinks" that the "This
Record" value for ID is 44.
Now suppose you click on CCC to make it the current record. As you
would expect, it "thinks" that the "This Record" value for ID is 33.
It also "thinks" (accurately) that the "CURRENT Record" value for ID
is 33.
But what do AAA, BBB, and DDD "think" is the "CURRENT Record" value
for ID? Danged if I can figure out how to compute this and
communicate it to them.
Let me explain just briefly why I'm trying to figure this out. I've
got a database where the records are subsetted into categories. The
specifics don't matter. Let's say the database tracks "Widgets" and
some of the values in the "Category" field are "doohickeys",
"whatchamacallits", "thingamabobs", and "deelybobbers". I call up a
record for a Gold-Plated Framistan Type 2, which falls into the
category "framistans". A link of "Category" to itself enables me to
display a portal showing ALL the framistans in the file, one of which
is, of course, the Gold-Plated Framistan Type 2 that we're currently
looking at.
What I want to do is display a yellow highlight behind the line in
the "framistans" portal on which the Gold-Plated Framistan Type 2
appears. If I then page back to the previous record, for the Platinum-
Plated Framistan Type 1, I want THAT record to be highlighted in the
portal.
How to do this?
