>>Our database system requires a hierarchy of users like so:
A
/ \
B C
/ \ / \
d e f g
/\
h i
User B can see/edit records allocated to B, d, e, h and i, but cant see any others. User d can see records allocated to them, h and i only, and so on.
How would you set this up in a database? <<

How about a simple "user level" 1-9

Any user can edit records where the user=himself or the userlevel
so A=level 9, B,C=level 8, defg=level 7, hi=level 6 and so on?


Gary.