Using output from straight table in another straight table

[smithc2005]

I have a data model that is working as intended for a straight table but I am running into an issue using the output of one table as input on another. Each Employee has an ID. I'm able to successfully pull a list of employees, but I need to pull their supervisors and their supervisor's supervisor. I thought I'd have to do it in 3 separate tables. Table 1 is fine, but for Table 2, and later Table 3, I am unable to figure out how to use a pulled field as a var to pull a record. 

Ideally, I'd like to pull the other Employee_Name's using the Supervisor ID from another.

Table1

Employee_Name	EMP_IP	Supervisor_ID
Bob	1	2
Susan	3	4

Table2

Supervisor_ID

2

4

[petter · Accepted solution]

It is not possible to use the "output" of one or any table as an input to any other table. However since the tables use the underlying data model and the selections being made in the fields you could achieve the same effect but you will need to use expressions/measures to "recreate" the output built on the same fields. It is not possible to directly link tables with each other.