Albert, Thanks for your reply - the bit I am really missing is as to exactly how the values from the lookup table are accessed. Is there a variable returned somewhere that identifies the row in the lookup table that is the row that was 'clicked on' ? (Maybe I have missed something rather obvious here.)
Thank you. Regards John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Albert Berry Sent: Friday, 23 September 2005 5:09 a.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: DB Lookup ListBoxes Perhaps you could use something along the lines of this (syntax is approximate.) SAVEROW UPDATE SCHED SET t1.col1 = t2.col3, t1.col2 = t2.col6 + WHERE t1.FKCol = t2.PKCol PROPERTY TABLE SCHED 'Refresh' --- John Docherty <[EMAIL PROTECTED]> wrote: > I have a form which displays data from a RATES table using a DB Lookup > Listbox, so that the Listbox displays the row in the RATES table that > matches the data in a column within a DBGrid, based on another table, > (SCHED). However I am unsure as to how I can use the On Click EEP to select > the row from the Listbox (RATES), to insert additional data into the SCHED > table. If someone can point me in the right direction that would be much > appreciated. > > > > Thank you. > > > > Regards, > > > > John Docherty > > > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.344 / Virus Database: 267.11.4/109 - Release Date: 21/09/2005 > > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
