J
JFG
I'm trying to utilize the Inventory Control template for
my department. I work in a stock room that issues out
items for use. Instead of having a Purchase Order form, I
need a way to update the inventory numbers - maybe an
issue form or receive form.
I would like to create a receipt type of form
where I list stock#, issue/receive amount, and it
automatically updates the quantity count in my database
and I can print out a receipt for the transaction (almost
like a purchase). I've tried select queries and update
queries to do this but I assume I'm missing something.
Thanks.
my department. I work in a stock room that issues out
items for use. Instead of having a Purchase Order form, I
need a way to update the inventory numbers - maybe an
issue form or receive form.
I would like to create a receipt type of form
where I list stock#, issue/receive amount, and it
automatically updates the quantity count in my database
and I can print out a receipt for the transaction (almost
like a purchase). I've tried select queries and update
queries to do this but I assume I'm missing something.
Thanks.