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.

 

[Steve]

You should have tables like these:
TblPart
PartID
PartNumber
<other part fields>

TblPartInventory
PartInventoryID
PartID
PartInventory
<other part inventory fields>

Build a form/subform. Base the main form on TblPart and the subform on
TblPartInventory. Use this form to enter new parts. When you enter a new
part in the main form you will be able to simultaneously enter the inventory
of the new part i the subform.

BTW, there is a one to one relationship between a part and that part's
inventory. Consequently you can include part's inventory in TblPart and not
need TblPartInventory.

Steve

 

[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.