Jan --

Have you looked into Nested Sets at all? I'm not sure if it's appropriate for your use case or not, but they're good for representing hierarchical data.

kabel