all ideas welcome... interesting db foreign keys question - hierarchy database stuff

[eluser]Dam1an[/eluser]
n0xies solution is the easy one, but as he said, can be VERY inefficient
Essentially, your data is heirachical, so maybe this will help give you some ideas.
There's also some threads on the forum about hierachical data, see if you can apply some of that to your situation

I know it must be doable, as if you imagine it as a tree, an item is linked to every node under it

Sorry I can't give any specific idea's on how, but my brain seems a bit dead right now