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 

Reply via email to