Heirarchy/Grouping

[Guest]

Looking for a way to design a table where I can have a master
"Classification" and then many "Sub-Clasifications". THe information would
then be presented into a list box. Example:

Computers
---Software
---Hardware
---Etc.

I'm suspecting this would work for "Projects" as well; example:

Microsoft (Company Name)
---New Software Development
---Hardware Testing
---Beta Testing

Any ideas?

 

[Guest]

Try two tables with a one-to-many relation.

 

[Guest]

Hi Karl, and thank you for the response.

I figured it would involve two or more tables. How do I control the
indenting in the list box? It doesn't necessarily need to have the --- I used
in my example, it could indent two or three spaces and that would work as
well.