Jan,
I have taken some training from Razzak but I just now have the time to start implementing it. I will be spending more time looking at RDOCS (we purchased that). It is just a matter of knowing how to use the tools I have. Sometimes I need a guiding hand to get started and then the "light turns on". Thanks again for your help. Jim ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Wednesday, November 05, 2008 4:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: edit lookups Jim, Glad to help. I would strongly recommend getting to one of the SuperAdvanced Training classes that Razzak put's on. This is where you learn techniques like this. Another useful tool is R:Docs. It's less than $100 and has all of the property commands for every object, including samples. Jan -----Original Message----- From: "Jim Belisle" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 5 Nov 2008 14:55:51 -0600 Subject: [RBASE-L] - Re: edit lookups Jan, I did as you mentioned below. It works like a charm. I am very unfamiliar with Component Ids and EEPs and know I have to experiment with them. As I convert my forms I am sure I will have more questions. Thanks for taking time for the simple questions. Jim ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Wednesday, November 05, 2008 2:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: edit lookups 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
