Identify strings into 2nd table's records then update 1st table (kind of Vlookup)

SunOffice

New member
Local time
Today, 08:36
Joined
May 6, 2015
Messages
3
Hi All,

Could you please help on below situation in MS Access 2013:

I have two database tables as below:
tbl1_MainDB --- It has a field named as "City" where I get huge data for some city names. Sometimes This field may have some unknown/new names which are not listed in our 2nd table ("tbl2_RefrDB")

tbl2_RefrDB --- It's a reference table which has raw names for cities, and then standard names of their city and state in another fields.

Target --- I want to create a VBA prorgram (Sql query) which can look from tbl1_MainDB.[City] to tbl2_RefrDB.[Raw_City] field, and if found then pick the "Standard_State" and "Standard_City" record values from there, and update into the 1st table "tbl1_MainDB".
...if not found in "tbl2_RefrDB" table, then user can be informed & ask for updating the new/unmatched city record as a new record in this table.

Please review the attached sample database for more details.

Thanks & Regards,
SunOffice
 

Attachments

As I am looking for a quick solution/help on it, so posted there too.
 
No problem with posting in two forums at the same time, just say that you have and provide the links so others can see whether their ideas have already been suggested

Have a look at this link

http://www.excelguru.ca/content.php?184
 

Users who are viewing this thread

Back
Top Bottom