Joined: 30 Jan 2005
|Posted: Sun Jan 30, 2005 3:23 pm Post subject: Calculated field
One other question to ask if you have a little time....
In a form, let's say I have 3 controls linked to 3 database fields :
ctrl1, ctrl2 and ctrl3 linked to qty_field, unitprice_field and price_field respectively
Is it possible to calculate ctrl3 from ctrl1 & ctrl2 and to have it automatically stored in price_field ?
any comments are welcome.
Thanks in advance.
Linux Mandrake 10.1 / MySQL 4.0.20 / OOo 1.1.3