I am working on a database that one of the functions will be to keep track of inventory of a few products of various sizes. I have a form set to enter when new products are added, but I am unsure of how to go about it so that when a new entry is created, a field showing the current qty is updated. I will also need to be able this total be deducted with another form that will track usage of the items. I would think that just simply linking the fields would cause the previous entries to be replaced, rather than added to. So, how do I go about creating this effect?
ex.
addition entry 1: Product A, Size 1, QTY 10
addition entry 2: Product B, Size 3, QTY 20
addition entry 3: Product A, Size 1, QTY 25
addition entry 4: Product A, Size 2, QTY 50
Should cause the QTY fields to show:
Product A, Size 1, QTY 25
Product B, Size 3, QTY 20
Product A, Size 2, QTY 50
Then when I had the following usage entries...
Product A, Size 1, QTY 1
Product B, Size 3, QTY 2
Product A, Size 2, QTY 5
It should cause the QTY fields to show:
Product A, Size 1, QTY 24
Product B, Size 3, QTY 19
Product A, Size 2, QTY 45
[Solved] Make Form Entries Update Inventory Quantities
[Solved] Make Form Entries Update Inventory Quantities
Last edited by AGoodwin on Tue Feb 26, 2013 6:47 am, edited 1 time in total.
Open Office 3.4.1
Microsoft Windows 7 Home Premium
Version - 6.1.7601 Service Pack 1 Build 7601
Microsoft Windows 7 Home Premium
Version - 6.1.7601 Service Pack 1 Build 7601
Re: How to Make Form Entries Update Inventory Quantities
Record all input and output.
Calculate the inventory.
Example: http://forum.openoffice.org/en/forum/do ... p?id=14074
With time stamps for the inputs and outputs you may even calculate the inventory at any time in the past.
Calculate the inventory.
Example: http://forum.openoffice.org/en/forum/do ... p?id=14074
With time stamps for the inputs and outputs you may even calculate the inventory at any time in the past.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: How to Make Form Entries Update Inventory Quantities
Thank you. Your solution works great and is so simple.
Open Office 3.4.1
Microsoft Windows 7 Home Premium
Version - 6.1.7601 Service Pack 1 Build 7601
Microsoft Windows 7 Home Premium
Version - 6.1.7601 Service Pack 1 Build 7601