copying records from one table to another

  • Thread starter Thread starter nzquikster
  • Start date Start date
N

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?
 
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.
 
Back
Top