There are a couple of ways to get this. One is to set a variable to the value of the PK in the table where focus is when you click.
Form Variable: vCustID = CustID And in the EEP: ... WHERE CustID = .vCustID A search of the archives should come up with versions using the form properties instead of the variable. I have not converted everything to this new syntax yet. --- John Docherty <[EMAIL PROTECTED]> wrote: > 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] > > 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]
