I want to create associations between users in my application. For instance there is a Program Director (Role:PD) which has many Residents (Role:Resident), similarly there is an APD (Role: Asistant Program Director) to each PD.
To each PD I want to show him only those Residents which belong to him i.e I want to filter the Residents by the given PD. I can filter the users by Resident role (by using the combination of GetAllUsers() & GetUsersInRole() methods) but I cannot seem to filter the Residents by their Program Directors as there is no way I can make associations between two role types in Membership tables.
What can I do to have this kind of functionality? Do I need to extend the Role Provider to handle this?