RE: Computation in one form from the other forms

Hi

A more normalised approach would be to have another table showing goods In,
and then make the calculation of current stock quantity on the basis of goods
In - goods Out = Current stock. For more info see this excellent example;

http://allenbrowne.com/AppInventory.html

TonyT..

"jppigao@xxxxxxxxx" wrote:

Good day!

Please bear with me with my current situation.

I need some help regarding my Inventory Monitoring Database i would
like to implement in our office. First, Here is what i am trying to
accomplish. We would like to create a database to monitor our
Inventory and make sure that all incoming and outgoing items are
monitored and documented if possible.

So what i have done so far is created a table and form for the main
stock items which i have the item id, description, u/m, etc. I also
created a table and form for the issue voucher where the information
such as user, department and site will be stored and in this issue
voucher form i have a subform which will handle the transactions for
the issue voucher like qty, description and how many qty for the item
issued to the user.

Now is it possible to total the qty of the Beginning balance of the
Main Stock Items minus by the qty issued in the subform of the Issue
Voucher?

i want to see the qty on hand in the main stock items form where the
qty on hand for that item will be safe and cannot be modified somehow,
it will just be like an added field where in the background it is
computing all the transaction for that item id.

I would like to start from here and if there are any confusion please
let me know and i will try my best to explain more clearly my problem.

I am thanking you all for giving a help site like this.

God bless!

John Paul A. Pigao

.

Relevant Pages

  • Re: Computation in one form from the other forms
    ... i will use to deduct quantity in the Main Stock form but the QtyonHand ... and a field for QtyonHand ... only getting one calculation for all of items in the table. ... created a table and form for the issue voucher where the information ...
    (microsoft.public.access.formscoding)
  • Re: Computation in one form from the other forms
    ... i will use to deduct quantity in the Main Stock form but the QtyonHand ... and a field for QtyonHand ... only getting one calculation for all of items in the table. ... created a table and form for the issue voucher where the information ...
    (microsoft.public.access.formscoding)
  • Re: Computation in one form from the other forms
    ... which refers to the curremt value of the field txtItemNumber ... in the form of the Main Stock where i have a field of Begbal ... and a field for QtyonHand ... created a table and form for the issue voucher where the information ...
    (microsoft.public.access.formscoding)
  • Re: Computation in one form from the other forms
    ... in the form of the Main Stock where i have a field of Begbal ... and a field for QtyonHand ... only getting one calculation for all of items in the table. ... created a table and form for the issue voucher where the information ...
    (microsoft.public.access.formscoding)
  • Re: Computation in one form from the other forms
    ... If you are doing this on a form bound to the main table with Qty in, ... A more normalised approach would be to have another table showing goods In, ... created a table and form for the issue voucher where the information ... Main Stock Items minus by the qty issued in the subform of the Issue ...
    (microsoft.public.access.formscoding)