Hello,

I have a "Parts_Table" which have all my parts in it.

Columns = Name - Description - Part Number 

I would like the users to add their inventory to their table from a pull down. When they go to the pull down menu they can select a part

Inventory Table

i.e. SparkPlug - A Sparkplug - PN#1234 - Quantity

When they select the part it will add a line item in the inventory table and allow them to add a quantity on hand.

I hope this makes sense?

Thanks