Sami, can you elaborate on "Be sure to trap for if the field is null vs. if they tab back into it because once it’s filled in you might not want the original lookup value to replace existing data." I have a similar form and if the user goes back into the field where the textvalue eep runs, it replaces the edited data with the lookup value. What is the best way to keep that from happening? Thanks
Date: Thu, 24 Jan 2008 07:28:59 -0800From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: [RBASE-L] - RE: Scrolling Region Sami, Thanks. Works now. Have a good day. Jan -----Original Message-----From: "Sami Aaron" <[EMAIL PROTECTED]>To: [email protected] (RBASE-L Mailing List)Date: Thu, 24 Jan 2008 08:57:05 -0600Subject: [RBASE-L] - RE: Scrolling Region Jan – Look up the value in an EEP, perhaps in the ENTRY EEP to the field in question, then use the PROPERTY command to set the TEXTVALUE of the field. The user can then change the value in the field. Be sure to trap for if the field is null vs. if they tab back into it because once it’s filled in you might not want the original lookup value to replace existing data. SELECT columna INTO vcolumna FROM sometable WHERE something PROPERTY columnbID TEXTVALUE .vcolumna Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansenSent: Thursday, January 24, 2008 8:22 AMTo: RBASE-L Mailing ListSubject: [RBASE-L] - Scrolling Region Been a while since I've worked with a scrolling region.I need to have a region lookup a price (similar to SalesOrder form)but also need to be able to change it. Currently I can change it but it reverts back to the original lookupupon leaving the fieldI know it's simple but it is escaping me this morning.Jan _________________________________________________________________ Climb to the top of the charts! Play the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_jan
