If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
From a Form subtract issue from bound QtyOnHand in a new record
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 |
#2
|
|||
|
|||
From a Form subtract issue from bound QtyOnHand in a new record
Paul,
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. |
Thread Tools | |
Display Modes | |
|
|