plus all the values in the TRANSAMOUN column on the subform_grid (ie. not just for the current row - but for all rows in the subform_grid).
sAmount2 = oForm.getByName("TRANSAMOUN").CurrentValue
OK ... So is there a way to get the aggregate value of a subform grid column into a field on a subform?
Alternatively I suggest you examine DACM's excellent invoicing example which exploits the underlying strengths of Base while avoiding unnecessary resort to macros that tend to be less productive given the comprehensive but complex OpenOffice API.I'm trying to write a macro for an invoice form that will populate a field with a "balance" value.
martinbone wrote:Many thanks for your advice Arineckaig. I've now added relationships to my database ... I do find it a challenging and educational exercise creating a database. One of my aims to to help demonstrate how powerful Base is - and what it can do ...
https://sites.google.com/site/libreofficedatabases/
martinbone:
One of my aims to to help demonstrate how powerful Base is - and what it can do ...
The issue is not to do with OpenOffice/LibreOffice but with relational databases. The relational database is founded on certain principles - e.g.mathematical set theory - and if the design is faulty the results will be unreliable.It would be nice to receive balanced feedback and receive at least one positive comment from people interested in OpenOffice / Libreoffice.
Users browsing this forum: No registered users and 5 guests