Credit/Debit value in table based on form entry

[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

 

[Steve Schapel]

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.

 

[KARL DEWEY]

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.