> THe following example is from my Advanced SQL > Queries book. We have an > entire chapter on this subject. Since you're > willing to limit your > structure to 4 levels, I have just the select for > you!
Thanks David -- I think this will do it. I notice that you did this with four UNIONs in one select. Have you tried it with four intermediate views. Doing that would let me determine right away whether a particular item was at the lowest nesting level and stop the user from entering any additional values underneath it. Thanks for the help! -- Larry
