I am designing a new database in SQL 2000. There will be GrandParent who will have Parents. GrandParents will have access to all the Parents and GrandChildren. Parents can have Children too. Parents will have access to only their Children. Children will have access to only themselves.
for example: ABC company (GrandParent) have 10 locations. ABC assigned 5 different logins to five managers (Parents) who are responsible for 2 locations each. Each manager also assign (1-3) logins (Child) to each location. Child is only responsible for their locations.
I am doing this project in asp.net/vb.net.
Tables will have these fields:
no of locations
If you like clarification feel free to ask.