One column returns value based on other column

K

keithbetsey

I have a column for the employee's name and it is a lookup field. I
want a second column to return the department that is in that record
of the table that the lookup field is based on. I.E. If we put John
Smith in the employee field then automatically the department
Accounting is returned in the department table.

Is this possible?
 
S

Steve Schapel

Keithbetsey,

You would use a Query, which includes both your main table and the
thable that the lookup field is based on.

Your statement "I have a column for the employee's name and it is a
lookup field" is probably not true. It is probably a column for an
EmployeeID or some such, which is the actual data in the field, and the
employees name only shown there because it is a lookup field. If this
is the case, then the join in your query between the two tables will be
to the EmployeeID (or whatever the field in common between the tables).
Then you will be able to include the Department field from the lookup
table in your query. Make sense?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top