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.
