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"
