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

Hi Borg,

I don't know which tool you are using but most tools are either support a
tabular input of the following form

books | Sci-fi books | robot books
Candy | Chocolate | <null>
Candy | hard candy | <null>

or a recusive structure like

books | sci-fi books
sci-fi books| robot books
Candy | chocolate
Candy | hard candy

Some tools require an explicit top- or root element which would require a
first column "Total products" in the first table and (maybe some additional
starting rows) for the second table like:

Total products | Total products
Total products | books
Total products | Candy

Hope this helps,

Kind regards Joerg