How to add just one field

[Bob]

I have two tables. They both have a field "Product_ID", and are linked on
this field.

One table has a field Vendor, every record in this field is empty.

The second table has the field vendor, and they are all filled in.

I would like to fill in the vendor field from the second tabel to the first
based on the product_id.

thanks

 

[Rick B]

Why? If the tables are related, it would be redundant to store the vendor
data in both. Just take it out of that second table. when you need to use
it, pull it from the first table.