Jim, Heres how to make that work in a scrolling region. 1. Delete the form lookup 2. In the field that is to lookup place a componentid such as LookUpValue 3. In the field that is to receive the lookup place a componentid such as ReceiveValue 4. In the On-Exit-EEP of LookUpValue place this code GETPROPERTY LookUpValue TEXTVALUE 'vLookUpValue' SET VAR vReceiveValue = PROCDESC IN PARTPROC WHERE PROCNUM = .vLookUpValue PROPERTY ReceiveValue TEXTVALUE .vReceiveValue
This will place the lookup in the field and allow you to edit it as necessary. Hope it helps. Jan -----Original Message----- From: "Jim Belisle" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 5 Nov 2008 14:13:06 -0600 Subject: [RBASE-L] - Re: edit lookups Jan This is a scrolling region. Jim From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Wednesday, November 05, 2008 2:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: edit lookups Jim, Is what you are trying to do in a ScrollingRegion or a DBGrid? Jan -----Original Message----- From: "Jim Belisle" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 5 Nov 2008 13:56:00 -0600 Subject: [RBASE-L] - edit lookups I am in the process of updating some forms from 6.5++ to the newest 7.6 version. I realize I can no longer edit lookup variables like I could in 6.5. The help suggests making an EEP before the form is launched. This form is for editing punches from the shop. The purpose for the lookup in one field is to bring information in that the employees missed, That is where the lookup comes in. I also edit existing information that needs serial numbers etc. The variable I now use is PROCDESC = PROCDESC in PARTPROC where PROCNUM = PROCNUM. How would I write the EEP before the form launched so I could use the lookup when necessary? Jim
