[RBG7-L] - RE: Form Lookups

[Dawn Oakes]

Marc   I'm assuming you're looking up the price and your Code column is used for lookup (but adjust the var below as necessary).  Also assuming all columns in the region that you want to edit are, in fact, columns in the scrolling region's table.   Define a variable vprice = price in lookuptable whe linkingcodecolumn=code In an on exit eep on the Code db_edit, PROPERTY <price_column_componentid> TEXTVALUE .vprice   This will use the price from the lookup, but also allow editing.  I use this for my purchase orders.  It looks up the last price paid, but allows the purchaser to change it when the price changes.   Dawn     From: Marc [mailto:[EMAIL PROTECTED] Sent: Thursday, February 10, 2005 3:54 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Form Lookups HI all   I know this has been talked about on the list before but I still can't grasp the concept.  I am sorry to bring it up again.   I know RB7 now uses true lookups and we can't edit or change the column values like we use to in 6.x.   I want the region to look like this Custnum  Date  Trantype   Code   Price    EstPrice   1) do I place the columns on the region or make a var     for Vprice and vEstPrice? 2) do I put a lookup in the expressions like we did in 6.x   to look up the price or on an Exit eep from the Code field? 3) I think I need to use a Property command but where do   I put it?  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.     thanks Marc