update second table

[Xfree]

I have a parts table and a inventory table, I would like to be able to update
the inventory table with the new part number when a new part number is added
to the parts table. How would I do this? I have the joins setup now and can
add a part number to the inventory table via a combo box.

 

[Klatuu]

What is the difference between a part and an inventory item?

 

[Xfree]

there is no difference they are one and the same but I am using a table for
inventory to track Pcs on hand of the part.

Sorry about the late delay, Hurricane issues.