I have a form that "Looks" up many fields based on one field. This particular form is based on a temporary table and I set the actual table columns to equal the variables. I then have the form use the variables as the fields in the form. This is one way to do what you want.
Another way is to simply to use the GETPROPERTY function. Below is an example of one triggered on EXIT EEP: GETPROPERTY LookUpValue TEXTVALUE 'vLookUpValue'. (The LookUpValue is the componentID name of the field where the EEP is located.) SET VAR vReceiveLookup = PROCDESC IN PARTPROC WHERE PROCNUM = .vLookUpValue PROPERTY ReceiveLookup TEXTVALUE .vReceiveLookup You can do this with multiple fields. Remember that lookups like above are not editable. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. Sinclair, MD Sent: Monday, May 25, 2009 3:47 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Help with EEPs in Rbase 7.6 Hi all, I now realize that lookups in forms that worked well in version 6.5 have to be replaced with EEPS in version 7.6. This will probably give me much more flexibility in my forms, but I am having trouble getting started. I have a few questions that might help me.... Do I use DBedits objects for Variable edit objects? Should the EEP be triggered from the field that was given the data or triggered by an ENTER on the first field that is going to get the lookup data? In my application, I want the user to be able to populate fields for a perscription based on a common abbreviation for that perscription. I have a table with look up data called SCRIPTS. The columns are called shortcut, drugname, dose, frequency, refills, comments. My form is allowing the user to enter data into a table called SCRIPTS1. The columns are all the same, with a few extra columns that are patient specific (patnumbr, rdate_), ie patient number and today's date. Is there a sample that I can look at? Or can somebody give me a little guidance on how to start? Mike

