Thanks Gunnar and Alastair That did the trick. I added an on-click eep with the RECALC VARIABLES. Oddly the thing I had to do to make the top part of the form work (the lookup box where the user types in the name they're looking for) was to REMOVE the recalc from the eep -- which I tried after reading the help screen on the change in how 7.6 handles lookup variables and define the key variable (vidno) in the on entry eep.
I love this list. I was so frustrated last night I shot off the question and went to bed. Woke up this morning to find your suggestions which I tried and my problem was solved! For someone like me with a lot less experience than many of you, this list and those of you so willing to share your expertise is a Godsend. Thank you! Paula Sent from my Verizon Wireless BlackBerry -----Original Message----- From: "Alastair Burr" <[email protected]> Date: Thu, 17 Sep 2009 08:10:30 To: RBASE-L Mailing List<[email protected]> Subject: [RBASE-L] - Re: Need help with converting form to 7.6 Paula, Do you have a RECALC VARIABLES in your EEP? Regards, Alastair. ----- Original Message ----- From: Paula Stuart To: RBASE-L Mailing List Sent: Thursday, September 17, 2009 2:23 AM Subject: [RBASE-L] - Need help with converting form to 7.6 Just upgrading a database from 7.1 to 7.6 and the form that is the primary lookup form is driving me crazy. I got the variable list lookups to work (had to read the help instructions for how this changed in 7.6) However the thing that's driving me bonkers seems like it should be easiest to do and doesn't seem to have changed from 7.1 unless I'm just missing something. The user types a name or a portion of a name into the form and the system displays a list of possible matches. When the user clicks on the correct name, two other variable list lookup boxes are populated with various transactional data. Got that all working fine. However there are variable labels that are just simple lookups (vhomephone = homephone in biofile where idno = .vidno) that just will not work. As I said, they work ifne in 7.1. There are several of these variable labels that should just look up info from the main table based upon the record selected. They just stay blank. What am I missing? Paula ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.100/2375 - Release Date: 09/16/09 05:51:00
