ContributionsMost RecentMost LikesSolutionsRe: I don't see a way to create a hierarchy from a table that just shows employee and manager.Thanks Debbie - I very well might. I hope you're doing well!Re: I don't see a way to create a hierarchy from a table that just shows employee and manager.Thanks for the clue. I'll see how far I can get. Note that the intuitive way you're suggesting doesn't work well with more people. For example, if I move a group to a new manager, it's easy to just update all their managers, but not easy to update everyone all the way up the chain from their new manager. And when a middle manager changes managers, you need to find them all over the place and update their reporting chain. It doesn't scale.I don't see a way to create a hierarchy from a table that just shows employee and manager.Is there a way to handle the recursion for any number of levels, so I could have one table that has: employee manager bill mary mary jane jane bob and from there I can make sure that jane can see the performance review of bill, for example. How can I start with the above table, with any number of relationships, and end with a table that has: employee manager1_ _manager2_ _manager3_ bill mary jane bob (As an aside, I have exactly the same problem with serial numbers on parts, that roll up to assemblies with a new serial number, but those assemblies roll together into larger assemblies with a new serial number, with N levels.) All help greatly appreciated!