Larry I;m glad it helps and your idea is an excellent improvment!
David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, July 12, 2004 11:08 AM Subject: [RBASE-L] - Re: Representing a tree in a table. > > 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 > >
