Inventory

Hi,

I am a new user of Access. I am trying to set up and
inventory tracking system for the company I work for.

I don't know how to set up the forms to track what
employee took, what quantity from a specific item
number.

I basically need the information we enter into a form to
be saved into a report. Right now when I enter in the
name of the employee and the quantity checked out the
information does go to a report that I created. The
problem is that when I go the same part number and choose
a different name and a different quantity it overrides
what was on my report.

Thanks for that help
Amanda

Hi, Amanda. It sounds like your editing an existing record, instead of
creating a new one. Inventory systems are probably one of the harder
"first-time" databases to create due to the need to have a *running balance*
of the inventory on hand. Hence, I'm thinking a table with many records
where the first record for EVERY inventoried item would be something like
"Balance on hand" instead of "employee". For instance, how will you handle
it when more inventory is purchased?

I personally would need to see a database to help, but I'm sure there's
others here who know exactly what you're running into.
-*--*--*--*--*--*--*--*-
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Com.Piersontech@Dreamboat
(Reverse it!)
Web: www.TheOfficeExperts.com
-*--*--*--*--*--*--*--*-

"Amanda" wrote in message
...
Hi,

I am a new user of Access. I am trying to set up and
inventory tracking system for the company I work for.

I don't know how to set up the forms to track what
employee took, what quantity from a specific item
number.

I basically need the information we enter into a form to
be saved into a report. Right now when I enter in the
name of the employee and the quantity checked out the
information does go to a report that I created. The
problem is that when I go the same part number and choose
a different name and a different quantity it overrides
what was on my report.

Thanks for that help
Amanda