Sorry for being confusing, let me try again.
Table A
Employee ID Number
Employee ID Name
Table B
Employee ID Number
I need a way for Employee ID Number in Table B to Look at Employee ID Number in Table A and return the cooresponding value in Employee ID Name.
So I need Table B column...