I posted this yesterday but it no show... hope no dupe!

Hi all,


I'm trying to load a tree of product categories from a single table,
in two different ways...first a tree of categories and subcategories
only:


idCategory Desc idparent
1 root 0
2 books 1
3 sci-fi books 2
4 robot books 3
5 Candy 1
6 chocolate 5
7 hard candy 5



The root has 2 subcategories "books" and "candy"

"books" has 1 subcategory "scif-fi" and "sci-fi" has 1, "robot books"

"candy" has 2 subcategories "chocolate" and "hard candy"


I got close but I got repeating values


Next same as above only with the products included.


I've played with the VB data environment for a week or so and it's
just not coming together...

TIA

BG