Hi Brandon,

Brandon Smith wrote:

> Frank,
> Thanks for the suggestion, I would like to look into something that
> would make the select "flatter." I'll search for nested sets and see
> what's out there. I would appreciate it a bunch if you could send me
> what you mentioned.

i've just uploaded it to my site:

http://www.fingerbird.de/downloads/FBNestedSetsDemo.zip (~10k)

it's nothing fancy, but shows how to set up the table and the
storedprocs for inserting/deleting/viewing the tree.

(in case you don't have ibobjects, you can copy the sql
script for the database from the appMain.dfm)

in case you have more questions, i'll probably not be able
to answer them until two weeks from now as i'm leaving
for the holidays tomorrow.

hth & cheers,
Frank