Highlight the portal record fields in layout mode. Select Format Menu/
Conditional. Under the condition, select Formula. In the calculation
dialog, have your "'framistans'" ID = to the parent record key. In
other words, if the parent key for the framisans record is equal to
the parent key of the current record, then do something.
Charlie
Bonding Solutions, Inc.
On Nov 4, 2009, at 1:51 PM, Richard S. Russell wrote:
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?
