[libreoffice-users] Re: Base: setting up a home pantry dbase aditional info

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: users+unsubscribe@global.libreoffice.org
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