Le 23/08/2018 à 16:22, lunixbox a écrit : Hi,
> Let say beans barcode 234 = Item-ID 2 Going in box-ID 1 ,then > the next item-ID 2 in box-ID 1 ETC. so you get a box-ID(x) = box-id(x) > +1 but the braindrain i get is How to get the selected box-ID into > the formula to add one item .And in a next formular to substract. It > start simpel and then it look like i want the world to inventory. As > stated its for some home use,more to stay busy in my retired years :) OK, so as I now understand it, you want a running total of all items with a given Item-ID (hence the inventory aspect). I would recommend that you read Robert Grosskopf's Base Guide and sample MediaDB (there are 2 examples, one without macros, and one with macros) - both relate to media stock management for a library facility, which has an inventory aspect to it. You will probably find the elements of what you are looking for in these examples. Alternatively, you could look at the following from the OpenOffice.org forum: Sample InOut inventory database: https://forum.openoffice.org/en/forum/download/file.php?id=24572 Discussion thread: https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=83077 Good luck ! Alex -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
