Best way to populate multiple fields in a table(A) from another table(B)'s fields using its(B) key

[pharmacologist]

I have a Access table that has a field relating it to a specific type of item in another table. That other table also contains information I'd like to include in fields in the first table as I routinely pull that data into Excel. Is there a way to populate those fields in the first table from fields in the second table using the second tables key in a field in the first table? Or is there a better way to do this to use in Excel?

thanks

[mike60smart]

Hi

It would help if you explain the actual process using actual field names.

[ranman256]

update query.
join the 2 tables and update all A fields need from B.

pull the key off the form or user entry.

[pharmacologist]

Hi

It would help if you explain the actual process using actual field names.

I have an "offerings" table with a field called "product type" and a table of "product types" with other fields such as "size" and "color". I would like to be able to also have some of the fields, like "size", in my "offerings" table filled in with the value from the related record in the "product types" table so that when I pulled the table into Excel, it also contains these values.

[mike60smart]

Can you upload your database?

[Dave14867]

You could use a ComboBox for "Product Type" and use that to populate fields on the form. Just be sure to include the data that you want populated, or like ranman say, use a query.

[June7]

Build a query that retrieves related data and export query to Excel.