From a Form subtract issue from bound QtyOnHand in a new record


Paul H

I want to make a simple current record transaction and update one field in
the main database for a unique item. The transaction would be to add an
issue record to an issue table and change the inventory table QtyOnHand field
based on the issue. Update queries are generally for multiple records, I've
tried using the Default property without any luck



Just my two cents here, but I would not store the Quantity on Hand in
a table. Storing "running totals" in databases is often a dangerous
thing to do. You are better off just storing all of the transactions,
and then getting the current QtyOnHand via a query/report whenever you
need to display it.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads