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"

Reply via email to