AutoPopulate field based on numerical value from seperate table

[Magnum45]

Hello Gang,

This is my first post and I'm hoping to get some great support! I have a specific issue and I need some guidance. I have MS Access 2013 and I'm trying to populate a field which currently contains numbers and change those numbers into company names. I have two tables. One table contains the name of the companies and next to it the associated numerical ID for the company name.

Then I have a contact table which only contains the numerical ID in place of the company name. I need to auto populate that number and change it into a name. Or add another column and add the Company name to the contact table. Please any advice?



Basically I need the company number to be the company name in my contacts table. See screenshot.

-Magnum45

P.S. I'm an Access newbie so basic instruction will be appreciated!

[ssanfu]

Welcome to the forum......

Then I have a contact table which only contains the numerical ID in place of the company name. I need to auto populate that number and change it into a name. Or add another column and add the Company name to the contact table. Please any advice?

OK, create a query and add the "contact" table and the "Companies" table.

Drag the "Companies.ID" field to the "Contact.Company field".

Add the fields to the grid that you want to see -> Contact.FName, Contact.LName, Companies.Text
Execute the query - and there you have it - the company name instead of a number.


("ID" is a poor name, BTW)
("TEXT" is a reserved word in Access and shouldn't be used as an object name)