Credit/Debit value in table based on form entry

  • Thread starter Thread starter Amanda.Perez.09
  • Start date Start date
A

Amanda.Perez.09

Hi,

I am trying to create an Inventory Log and I would like for the
quantity of parts entered in the form to either increase or decrease
the value in the table, but I'm not sure if I need a macro to do this
or what exactly I need.

I am a newbie to access, so I don't understand any code. Please help!

Amanda
 
Amanda,

In an invenory database, what you are proposing is a bad idea. The
"quantity on hand" of the items in your inventory should not be stored
in a table. All you should store in the database are the details of the
transactions (parts in and parts out). The quantity on hand should be
calculated via a simple Totals query, based on the transactions data.

Sorry for the broad brush stroke here, but please review the basic
concept first, and then we can look at specifics.
 
In addition to transactions (parts in and parts out) you would want a
transaction of inventory adjustment to bring the quantity on hand calculated
via a simple Totals query, based on the transactions data to match the
physical count.

Include a text or memo field for show justification for the discrepancy.
 
Back
Top