Good day,
First would like to say I use this site to find more trivial stuff than anyplace else.. THANKS!!!
Been looking for a few hours on this and seem to be not asking the correct question.
I am attempting to build some "Strategic Planning" software and my boss would like to see a tree or heiarchial structure:
Example:
1. Pet Products (category)
..1.1 Food (Sub category)
...1.1.1 Cat (product)
....1.1.1.1 Soft
....1.1.1.2 Dry
...1.1.2 Dog
..1.2 Toys
2. Human Products
The way I currently have it setup is an individual table for each layer of the tree/heiarchy. Then utilizing relationships making each "Sub" drive off the previous level.
Everything in my past experience is saying this not the correct way of doing things, but can't find anything to tell me whether it is right or wrong, or dirty programming.
So my questions: A) Is this the right approach? and B) what is the technical term for this type of data grouping?
Thanks in advance,
Kendall
First would like to say I use this site to find more trivial stuff than anyplace else.. THANKS!!!
Been looking for a few hours on this and seem to be not asking the correct question.
I am attempting to build some "Strategic Planning" software and my boss would like to see a tree or heiarchial structure:
Example:
1. Pet Products (category)
..1.1 Food (Sub category)
...1.1.1 Cat (product)
....1.1.1.1 Soft
....1.1.1.2 Dry
...1.1.2 Dog
..1.2 Toys
2. Human Products
The way I currently have it setup is an individual table for each layer of the tree/heiarchy. Then utilizing relationships making each "Sub" drive off the previous level.
Everything in my past experience is saying this not the correct way of doing things, but can't find anything to tell me whether it is right or wrong, or dirty programming.
So my questions: A) Is this the right approach? and B) what is the technical term for this type of data grouping?
Thanks in advance,
Kendall
Comment