Larry: This has changed big time; it does not work the way it used to in previous versions (6.5++ and prior). You need to use EEPs if you want to do this; you can look at Concomp examples for guidance. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Lawrence Lustig Sent: Tuesday, August 10, 2004 12:15 PM To: RBG7-L Mailing List Subject: [RBG7-L] - How are form lookups evaluated in v7.x? I'm putting together a form. I want to use the form in both Enter and Edit mode. I have a column for ControlNum and a column for CustCode. When the user enters the ControlNum, I want to look up the expected CustCode in another table and set the CustCode column to this value. I then want the user to be able to change the CustomerCode value if necessary. I believe in prior versions, the lookup would happen only when the variable or column on which it depended changed. That is, the expression CustCode = CustCode IN ControlTbl WHERE ControlNum = ControlNum would only evaluate when the ControlNum column on the form changed. Now, it evaluates as soon as a I type over the CustCode value, and the CustCode value gets set back to the default from the ControlTbl. Question: Am I remembering correctly the way it used to work? Has it changed or not changed in version 7? Is there a setting I can switch to change it back to the old behavior? Or a work around? -- Larry
