Two Tables with equal field need to display third column

[sbreegle]

I have two tables that each have a column that is the same but the first table has two columns the Employee ID Number and Employee ID Name and the other table just has the Employee ID Number in it. How can I get the big table with only employee id number to display the employee ID name instead?

 

[cookiegary01]

Hi,
Table A contains [Employee ID Number] and [Employee ID Name].
Table B contains [Employee ID Number].
Now you want the big table (A?) with only employee id number to display the employee ID name instead? Sorry you've got me confused.
Perhaps you should read your post again, and try to rephrase your question?

 

[sbreegle]

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 Employee ID Number to display Employee ID Name

 

[cookiegary01]

Hi
Thats what relationships and queries are for.
Table B will not display Employee ID Name, but a query can.
Create a query, and add both tables.
Then make a relationship between both Id Numbers.
Check the video tutorials on General,Tables and Queries.
A world will open for you.