Point me in the right direction.

[srwmemphis]

I am new to access and need someone to point me in the right direction.



I designed two simple tables to keep up with parts being checked out of inventory.
The first form has two fields "Part Number" and "Description" It has already been populated with all my data. Part number is the key field.
The second table is for parts checkout and also contains the same two fields "Part Number" and "Description" along with a few other fields.
I want to be able to enter the "Part Number" in the "Parts checkout" table and have access go to the "Parts" table, retrieve the "Description" that is for that part number and put it in the "Description" field in the "Parts check out" table.

I have built a relationship between the two tables linking the "Part Number" fields from the "Parts" table to the "Parts checkout" table.
Not sure where to go from there

Any help would be appreciated.

Thanks

[June7]

Why duplicate data between tables? This violates basic relational database principles. Description should not be saved into Checkout table. Retrieve related info in queries that join tables.

[srwmemphis]

Why duplicate data between tables? This violates basic relational database principles. Description should not be saved into Checkout table. Retrieve related info in queries that join tables.

Oh! Thank you so much. That helps so much. You are awesome.