Re: Calculation in new form field (Newbie question)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Frank Schönheit - Sun Microsystems Germany wrote:
> Hi Gert,
> 
> 
>>Assume I have two table fields Qty and CostPrice. How can I create a form
>>field that displays the result of Qty * CostPrice?
> 
> 
> You cannot do this in a form, but in a query. Create a query which
> contains all fields of interest, plus "Qty * CostPrice", and base your
> form on this query.
> 
> Ciao
> Frank
> 

Well but that wouldn't be updated until you save the form. Better way
would maybe be writing a Macro which listens on the focus events of the
2 fields and updates the 3rd one?

Tom
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)
Comment: Using GnuPG with Mandriva - http://enigmail.mozdev.org

iD8DBQFDO+IRkVPeOFLgZFIRAq4AAJ422ym59RhCpOryEKzdmJMepjUVrQCfe16U
bsZ8q6sYBgNJgamYF5S/rYg=
=7qaf
-----END PGP SIGNATURE-----