I am developing an inventory database. The warehouse operator has an
"Edit Inventory" form where he makes changes to incoming quantities.
He can pull up a line item, and enter how many just came in the door,
which will in turn update the total quantity.

I need to be able to log each of those transactions, so that I can run
a report showing all inbound activity. Or for a given line item, I
could run a report showing all the inbound transactions for a given
period of time. What's the best way to capture this info?

Have you looked at Allen Browne's Audit Tracking? It's fantastic -
easy to use and clear instructions.

http://allenbrowne.com/AppAudit.html

Sara

igendreau wrote:

I am developing an inventory database. The warehouse operator has an
"Edit Inventory" form where he makes changes to incoming quantities.
He can pull up a line item, and enter how many just came in the door,
which will in turn update the total quantity.
>
I need to be able to log each of those transactions, so that I can run
a report showing all inbound activity. Or for a given line item, I
could run a report showing all the inbound transactions for a given
period of time. What's the best way to capture this info?

I see Allen recently updated the code for this? (July 2006). I've been
using the old code for a while, does anyone know what functionality is
changed/added up updating to the new code? i didn't want to go through
all of my forms and change it if it wasn't necessary at this point.
The old code seemed to work good.

sara wrote:

Have you looked at Allen Browne's Audit Tracking? It's fantastic -
easy to use and clear instructions.
>
http://allenbrowne.com/AppAudit.html
>
Sara
>
igendreau wrote: