I think I need a self-join TO? Please help

[Jimjmn]

I will start with a novice apology. I am wanting to create an employee records DB and each employee will have a manager listed. That being said I would like to be able to list all employees that a employee (manager) has under them in a portal (see attached file). I have played with _pk and _fk to no avail. What am I doing wrong? I'm thinking this is easily achieved with a self-join but maybe I need an join table?

test.fp7.zip

[bruceR]

Like this?

testEmployees.fp7.zip

[Jimjmn]

You are the man Bruce. Thanks so very much!!!