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]
