Marc Not a problem. Keep one thing in mind. You do not have to use Variables to use this command. In regions I prefer to use a Dbedit. But I do not have the experience the other programmers do either. Just a preference.
Good luck, Fran Yount 708 NE Diamond Ln Lee's Summit, MO 64064 816-478-4858 PH 816-2003926 Cell 140*1084*123 DC [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Marc Sent: Thursday, February 10, 2005 4:21 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Form Lookups Thanks Razzak, Dawn and Fran I will get to work on it. I guess it IS hard to teach an old dog new tricks! Marc > At 03:53 PM 2/10/2005, Marc Shluter wrote: > > >4) I can get the first row to work but when I enter the 2nd row > > the vPrice and vEstPrince in the first row changes to the values > > of the 2nd row. > > > Marc, > > The lookup values for column/variable defined as expression, > are true lookup values in R:BASE 7.x/V-8 "Turbo" and cannot > be overwritten. > > A few options: > > ================================= > A. Using the classic EEP method: > ================================= > > To achieve the old functionality (as in 6.5++), you'll need > to define all lookup values as expressions, etc., in an EEP > (Entry/Exit Procedure) for column(s)/variable(s). > > To understand this process and the correct logic, take a > look at the "Sales Order" routines of Running R:BASE Your > Way! (Part 8 or Part 9). > > Database: RRBYW8 or RRBYW9 > Associated Form: SalesOrder > > Here's how: > > 01. Start RBG7 > > 02. Switch the working directory to RRBYW8 > > 03. CONNECT RRBYW8 > > 04. RUN RRBYW8.DAT > > 05. RRBYW8 Main Menu | Sales | New Sales Order(s) > - Select Transaction Date > - Select Sales Rep > - Select Customer > Notice the "Bill To:" and "Ship To:" addresses > - You should be able to change these addresses, if you > wish. > 06. Click on the "Line No." column and notice the automated > Line No. > > 07. Double-click on the "Model" column and select any model > from the Pop-up menu. > > Notice the true lookups for: > . Product Name > . Location > . List Price > > 08. Enter 10 for the "Discount %". > > 09. Enter 2 for the "Quantity" and press [Enter] > > Notice the calculated "Extended Price" and automated line > number for the next row. > > Also, note the Sub-Total, Freight Charges, Sales Tax and > Invoice Total. > > 10. Click on [Continue] button. > > 11. Click on [Yes] to "Print Invoice?" dialog box. > > 12. Select Screen for the report output and click on Continue. > > 13. Notice the appropriate Billing and Shipping Addresses > as modified in Sales Order form. > > ========================================== > B. Using the GETPROPERT/PROPERTY Commands: > ========================================== > > 01. Follow the suggestions posted by fellow list members. > > 02. http://www.rbase.com/getproperty > > 03. http://www.rbase.com/property > > 04. Read FormProperties.pdf > > 05. R:Docs > > Hope that helps! > > Should you require further assistance, feel free to ask. > > Very Best R:egards, > > Razzak. > >
