> Record 1: "01" (Main cat) > Record 2: "0304" (sub cat 4 of main cat 3) > Record 3: "02010107" (sub-sub-sub-cat 7 of sub-sub-cat 1 > of sub-cat 1 of main cat 2) > > Then just order by record ID.
that's actually quite neat, bj lots of code, but workable better allow three digits for future expansion, eh ;o) also, if you ever move a subcat into another main cat, you're screwed, er, i mean, you have to renumber everything that's affected... but it's still manageable, it means even more code, but it's manageable nice one rudy ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
