copying records from one table to another

[nzquikster]

I have two tables. one has a list of all parts and their information. the
other one has a bill of materials with just the part number. what i want to
do is populate the information for each part in the bill of materials by
using the table with all the parts. how would i do this?

 

[Jerry Whittle]

You don't actually want to move records from one table to the other. Rather
you want join the two tables in a query to gather all the data that you need.
You probably want to join on the part number fields. Hopefully the part
number is unique (AKA the primary key field) in the parts table or you may
have some incorrect results.