I'm looking for a way to demonstrate a subtotal of a numeric sub-form column while entering data. To help explain, I'll use the animals/people/thing example odb file referenced in http://nabble.documentfoundation.org/Base-form-table-grid-new-record-on-top-td3314448.html#a3320872 this thread .
The table structure in the example includes and intermediary P_T used to cope with a many to many between Persons and Things. But let's add a numeric column to the P_T table that would allow us to track multiples of a single thing. So, for example instead of noting that a person has a single hammer, and an axe, we could track instead that they have 34 hammers and 16 axes. What I want to do is add a subtotal by record on the form (doesn't matter if I need to refresh - that's OK). Is there a way to query WHERE record = current? If so, it seems I could put that on the form. For the sake of further explanation, I have a PDF file that tells me at the top that a person has 400 things (e.g. 34 hammers, 16 axes, etc.). And then I have to manually search through the PDF to find out what those things are. I'd like the form to help calculate things for me so when I make an entry (and push "refresh") I can see that I've so far entered 345 things for this person (better said, this one record) and need to keep searching for the other 65. Make sense? -- View this message in context: http://nabble.documentfoundation.org/Base-subtotal-by-record-in-form-tp3321062p3321062.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
