I’m not sure of the proper way of phrasing this, so I’m probably just not searching correctly.
Here’s my situation. Ideally, I’d like to do this with just 1 table.
People (Table)
Employee (Primary)
Manager (linked field to Employee showing that Employee’s manager)
Direct reports
What I’d like is a third field, Direct Reports, that links me to everyone who has that “Employee” as their “Manager”, (and for it not to be just a string, but a link to the record). This is definitely not make-or-break, I just wanted to see if it were possible/how I should be thinking of it.
Thanks!
