Hello, I have a data in which i have the employee name and the manager name. I want to create a search where if someone select a name ( For Ex: John) it should return records where John is Manager Directly or Indirectly . In below Example if i select John it should return all 3 records, Joy, Adam and Roy because Adam reports to John and Joy and Roy reports to Adam. If i select Adam, it should only return 2 records, Joy and Roy. _time FirstName Manager Name 08th March Joy Adam 07th March Adam John 06th March Roy Adam Can someone please help, how can i do that ?
... View more