Pathetic... I Cannot Figure Out A Seemingly Simply Query

Alright people... I'm ashamed to even ask but here goes.

I have two tables:
1) Employees
2) Neighborhoods

Table Employees has a comprehensive list of all employees and their information (including phone numbers).

Table Neighborhoods has lots of information about each neighborhood we're working in and it also specifies what people play certain roles in each neighborhood. For instance, there is a field for "Field Manager" and "Sales Consultant". These two fields are exact matches of "Full Name" from Table Employees.

All I want is for my Neighborhoods Table to be updated or a new table be created that imports the "Field Manger Phone Number" into the Neighborhoods Table and the same for the "Sales Consultant".

-----------------------------

To be explain one other way, this is what I want:

Table: Employees
Field: Full Name
Field: Phone Number

Table Neighborhoods
Field: Field Manager (already equals Full Name)
Field: Sales Consultant (already equals Full Name)
Field: Field Manager Phone Number (This is the field I want pulled from Table Employees)
Field: Sales Consultant Phone Number (This is the field I want pulled from Table Employees)

-------------------------------

I've tried my best to create an Update Query or a Make Table query but I have not gotten any good results. Can someone please help me out with this being very descriptive as I am certain I'm just goofing one simple step.

Thanks in advance.