Mapping Companies and thier Codes (2 tables)

[Guest]

I have two tables.

Table 1: Consists of many companies

ID Name
1 ABC Company
2 AA Company
3 CC Banking
4 Denty Texturizing
5 LG Electronic
6 Acer Computer
7 Asus Computer
.. .
.. .
.. .
-----------------------------------------------------------------------
Table2: list of company names and their internal codes (Mapping Table)

Company_Name Internal_Code

ABC COmpany 001312
Acer Computer 013214
Asus Computer 546546
Dexin Food 054846
Sara Lee Food 540487
LG Electronics 451017
..... ......
---------------------------------------------------------------------------------------------
My Question:

I need an SQL query (if necessar) or if any other way else (please kindly
explain me!)

i need those companies (table1) to match their "Internal_Code"(table2)
automatically.



Or, is there any other built-in functions in MS Access that i do it this way ?


I know how to do this in excel (by using VLookup) ,but is there any function
that i can do it in MS Access ?.


Thank you so much ^_^!

 

[John Spencer]

Add both tables to a query
Drag from CompanyName in one table to CompanyName in the other table.
Select the fields you want to see
Run the query.

Do this whenever you want to see information from both tables.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..