Trying to fill in available data on a list where most items are also in my table

I have created an Access Table including many companies which i have contact information for separated into company Name(unique id), phone, fax, email, contact person. I am trying to give access another list of just company names and all other previously mentioned fields blank. I would like access to fill in the available data that i have from my original table, then let me export back to excel where i can "google" the missing information.

I have searched hi and low for this kind of action, but i can not come up with the correct "vocabulary" for a search engine to know what i am talking about.

Have tried autopopulate, autofill, list building, and others to no avail.

Please provide me with at least a hint, the correct term, or a step by step process.

My gratitude goes to you!

Hi MattyNinja,

Assuming you have created:

- a "Master List" of companies in a table titled "tblCompany". This table contains: a primary key (CompanyID) which is usually an autonumber, but can be the company name if you insist there will be no spelling errors; and, contact information for each company.

- a shorter list of companies tblCompanyCheck that require contact info from your master list. This table also uses the same primary key as "tblCompany".

In summary you should have two tables:

tblCompany
CompanyID (PK)
ContactPhone
ContactFax
ContactPerson

tblCompanyCheck
CompanyID (PK)

With this you should build a select query. In the query you should join the two tables using the primary key. In the result of the query you should display the CompanyID field from tblCompanyCheck, and the contact fields from tblCompany.

Run the query and Copy - Paste it to Excel as required.

Cheers,