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"
