Prev: Issues after 2K7 Conversion
Next: Using Outlook meeting reminder as event registrant follow-up
From: Paul H Paul on 19 Mar 2010 13:24
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
From: ghetto_banjo on 19 Mar 2010 14:02
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.
 | 
Pages: 1
Prev: Issues after 2K7 Conversion
Next: Using Outlook meeting reminder as event registrant follow-up