One column returns value based on other column

  • Thread starter Thread starter keithbetsey
  • Start date Start date
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?
 
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?
 
Back
Top