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

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

duplicate thread here

http://www.accessforums.net/queries/identify-strings-into-2nd-tables-records-then-52214.html

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

Thanks! I will take care...

Regards,
SunOffice