Would it be possible to fill all of the fields after entering just the
first field so that the use would not have to tab into each field
individually to fill them?
Mike
A. Razzak Memon wrote:
At 09:17 PM 4/14/2008, Michael Sinclair wrote:
Is there a way, from within the form, to allow the fields to be
filled with data (from a lookup table) and still allow the user
to change the data?
Yes!
Define an "On Entry Custom EEP" to populate the lookup data gathered
using the SELECT colname INTO vVarname ...
Using this approach you are not dependent on the expression which
will reset/recalculate when you leave the field.
In my scenario, the user enters an abbreviation for a medication,
and the form populates all of the fields with the most common data
associated with that medication. Most of the time, no changes are
need. However, there are times, when only one of the fields need
to be changed. In Rbase 6.5, the data entry in this scenario was
lighting fast...the user would type in some 3 letter abbreviation
(which would populate all of the fields from the lookup table) and
then tab to the field that needed to be changed, and change it.
All the other fields that had data would be left unchanged. Can
that be done in ver 7.6?
Remember, nothing is impossible!
Take a look at the "Sales Order" processing defined in Running R:BASE
Your Way! (Part 14).
Exploring this form and the routines involved in the whole process
should give you a detailed and practical approach to achieve your
goal.
RRBYW14 Main Menu | Sales | Enter New Sales Order(s)
Do yourself a favor and make sure to go through the entire process to
understand the technique.
Have fun!
Very Best R:egards,
Razzak.
