Auto fill fields in sub form

[Emily]

Hi I am making a database to track my inventory. Some inventory items are
made of parts. ( I am a jeweler and make a lot of pieces and purchase ready
made pieces) I have set up a

Finished Inventory table
ID
Vendor
Style_ID
Invoice_Number
Description
Quantity
Cost
Retail

Parts Inventory Table
ID
Vendor
Style_ID
Invoice_Number
Description
Quantity
Cost

Finished Inventory Detail Table
Finsihed Inventory ID
Parts ID
Descrition
Cost
Quantity
Total

I have made a form for my Finished Inventory with a sub form for Finished
Inventory Details. I want to put in the Part ID Number and have the cost and
the description automatically fill with the info that matches the Part_ID.
How do I do this?

 

[Emily]

OK I figured this out. I used the description and the cost from the parts
table and made a relationship between the two tables with the part ID.