Instead of a report variable, use an eep based on the entered value of
Equip_number.
Set a component id in the Equip_Number property.
use GETPROPERTY vNo TEXTVALUE 'vPartNo'
in your eep where vNo is the component id and vPartNo will contain the text
value of Equip_Number.
Then you can do a select to get the description.
Then use PROPERTY TABLE <FormTableName> 'REFRESH'
Bernie Lis
----- Original Message -----
From: "Dennis Fleming" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Wednesday, August 17, 2005 10:01 AM
Subject: [RBG7-L] - Scrolling Region behavior
Looking for a workaround to avoid "slot machine" behavior for variable
look ups.
Scrolling region rows have two popup dbedit values and form flashed
through all possible values for a different variable after popup is
selected and you move to the next row, making form run very slow. In from
Variables:
vEquipDesc = Equip_Desc in Equipment where Equip_Number = Equip_Number
After selecting the popup value for a different column in the row and
moving to the next row, all possible values for vEquipDesc are displayed
on the row you just left.
Anyone else observe this behavior and/or have a fix/workaround?
TIA,
Dennis
*****
Dennis Fleming
IISCO
http://www.TheBestCMMS.com
Phone: 570 775-7593
Mobile: 570 351-5290
