add a field from one table to a field in another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to Assign parts on one form by job number and quantity and want it to
automaticaly subtract from inventory on another table
 
Tmiller,
Not much info to go on, but...
Usually in any Inventory system, a Disbursement should not involve
"deleteing" a corresponding Part from stock.
Rather, Parts are received as + transactions, Disbursements are handled
as - transactions, and the actual OnHand is the sum of all those
transactions.
Actually, the best way is to have a table that contains both Receiving
and Disbursing records, in one table. Think of your inventory system as
just a "checkbook" Money come in and money goes out... from the same table.
The sum, at any time, is the balance.
 

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

specified field [equipment] could refer to more than one table listed in FROM clause of SQL statemen 1
Add/Subtract columns from tab to tab in same file 3
Assign a Table field a value from a form 1
how do I make a number entered in one table subtract from another 2
Display Report Total in Form 1
Dsum Issues 0
Calculate form field using another table, Dim statement 0
Creating Criteria For Data Entry 3

Back
Top