[Solved] Make Form Entries Update Inventory Quantities

Creating and using forms

[Solved] Make Form Entries Update Inventory Quantities

Postby AGoodwin » Sun Feb 24, 2013 5:25 am

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
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
User avatar
AGoodwin
 
Posts: 14
Joined: Tue Feb 19, 2013 3:38 am
Location: New Hampshire

Re: How to Make Form Entries Update Inventory Quantities

Postby Villeroy » Sun Feb 24, 2013 9:56 am

Record all input and output.
Calculate the inventory.
Example: download/file.php?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, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26638
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How to Make Form Entries Update Inventory Quantities

Postby AGoodwin » Tue Feb 26, 2013 6:47 am

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
User avatar
AGoodwin
 
Posts: 14
Joined: Tue Feb 19, 2013 3:38 am
Location: New Hampshire


Return to Forms

Who is online

Users browsing this forum: No registered users and 2 guests