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.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Tmiller" <(E-Mail Removed)> wrote in message
news:21D1D638-8D40-4D0A-BE97-(E-Mail Removed)...
>I want to Assign parts on one form by job number and quantity and want it
>to
> automaticaly subtract from inventory on another table