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?
This sounds more like a data relation between objects rather than an extension of the rle provider. Roles are basically a grouping of user types rather than actual users.
I would approach this using an additional table to define the relationship between a PD and their Residents, and use the roles to design the administration page, e.g display all users in role PD, and below display all users in role Resident to assign