Lizam
|
| Posted: 07/14/2005, 6:08 PM |
|
Hi,
Since CCS does not allow this, can someone suggest a workaround?
Let say i have a record as such:
Opening stock XXX.XX
Local Purchase XXX.XX
Import XXX.XX
Country1 XXX.XX
Country2 XXX.XX
I want the user to specify the details - countries and amounts, sum them, and populate the value to the total import value.
Thanks in advance and best regards.
|
|
|
 |
Curtis
|
| Posted: 07/27/2005, 5:44 AM |
|
Record as it a page with a record form on it I'm assuming you mean....
I don't quite understand what your asking for....
Ok so you have a record, a user enters in some numbers in some of the field....and you want to sum those numbers and update a field in a table with that summed value, along with the country info for that record....this is what I think I'm understanding....
If that's the case....
Make the value that's going to be updating the table a regular database column control source type, and the other values that are going to be summed, will be code expression control source types....then just use php to add the two code expression source types and put the results into the column control source type...
Event: Before Execute Update (or something like that)
$form->import->setvalue($form->openingstock->getvalue() + $form->localpurchase->getvalue());
You can make the import field hidden on the record page.
|
|
|
|
|
