Thanks Neven I didn't realise that rhe Softouch DBLookupCombo Synched the tables. So much easier. regards Chris > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Neven MacEwan > Sent: Wednesday, 18 October 2000 15:53 > To: Multiple recipients of list delphi > Subject: Re: [DUG]: Calculated fields > > > Chris > > In that case easy - your DBLookupCombo will Synch the size table > so you can ref to it in your OnCalcFields event > > HTH > Neven > > > ----- Original Message ----- > From: Chris Wallis <[EMAIL PROTECTED]> > To: Multiple recipients of list delphi <[EMAIL PROTECTED]> > Sent: Wednesday, 18 October 2000 15:44 > Subject: RE: [DUG]: Calculated fields > > > > Neven > > > > I'm using a softtouch DBLookupCombo to lookup the size from > the grid on > the > > id. > > > > Database is MS Access and connecting through MDAC/ADO. > > > > > > regards > > > > Chris > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On > > > Behalf Of Neven MacEwan > > > Sent: Wednesday, 18 October 2000 15:05 > > > To: Multiple recipients of list delphi > > > Subject: Re: [DUG]: Calculated fields > > > > > > > > > Chris > > > > > > Several Options > > > > > > 1/ Do it at the server with a view (if using SQL) > > > 2/ Use a Master Detail to the size table and pick it up > onCalcFields > > > 3/ Use a DBLookupCombo (like softouch) that has the option to > > > synch lookup > > > table > > > > > > It is easier to direct you if I knew the databae and > connection method > > > > > > HTH > > > Neven > > > > > > > > > ----- Original Message ----- > > > From: Chris Wallis <[EMAIL PROTECTED]> > > > To: Multiple recipients of list delphi <[EMAIL PROTECTED]> > > > Sent: Wednesday, 18 October 2000 14:16 > > > Subject: [DUG]: Calculated fields > > > > > > > > > > Hi > > > > > > > > I have a dbgrid that looks as follows: > > > > > > > > Size 0.9 1.2 1.5 Cubed > > > > 100x50 1 5 2 0.0495 > > > > > > > > Size is extracted from another table by using an id key > and a lookup > > > > combobox that saves the sizeid in the table that makes up > > > each line in > > > grid. > > > > Size table has these fields: > > > > id Size LinealFactor > > > > e.g. 15 100x50 0.005 > > > > > > > > GridTable has these fields: > > > > id Sizeid 0.9 1.2 1.5 > > > > egg 2154 15 1 5 2 > > > > > > > > How can do extract the lineal factor from the size table > > > and use it to > > > > calculate the cubed? > > > > Cubed=(0.9*1)+(1.2*5)+(1.5*2)*100x50 lineal conversion factor > > > > Cubed=9.9*0.005 > > > > Cubed=0.0495 cubic metres > > > > > > > > regards > > > > > > > > Chris Wallis > > > > > > > > > > > -------------------------------------------------------------- > > > ------------ > > > - > > > > New Zealand Delphi Users group - Delphi List - > > > [EMAIL PROTECTED] > > > > Website: http://www.delphi.org.nz > > > > To UnSub, send email to: [EMAIL PROTECTED] > > > > with body of "unsubscribe delphi" > > > > > > > > > > -------------------------------------------------------------- > > > ------------- > > > New Zealand Delphi Users group - Delphi List - > > > [EMAIL PROTECTED] > > > Website: http://www.delphi.org.nz > > > To UnSub, send email to: [EMAIL PROTECTED] > > > with body of "unsubscribe delphi" > > > > > > > > > > > -------------------------------------------------------------- > ------------ > - > > New Zealand Delphi Users group - Delphi List - > [EMAIL PROTECTED] > > Website: http://www.delphi.org.nz > > To UnSub, send email to: [EMAIL PROTECTED] > > with body of "unsubscribe delphi" > > > > -------------------------------------------------------------- > ------------- > New Zealand Delphi Users group - Delphi List - > [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > > --------------------------------------------------------------------------- New Zealand Delphi Users group - Database List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
