Combo Box/System to Track Topics

[CT Witter]

Having a little bit of a problem designing how I need my data tables to function with topics for reporting.

I want to have N levels of hiearchy: such as Topic, SubTopic1, SubTopic2, etc.

Currently, I'm only using 3 levels.

Then I want to have descriptions for each type of item. Such as Topics can be Reports, Systems, Tests, Workflow, etc.

The sub topics would then fall under these. Such as Envir1, System Plan.

The problem comes in how do I restrict the user to using combo boxes to select a topic, subtopic, etc. that makes sense.

For example I can't have a system plan as a report.

What I'm looking for is some guidance or examples making a hiearchy that is easy to update, allows the user to do drill down based on combo boxes, and respect data validation.

Thanks,
CT

 

[Norie]

If there is a TopicID for each topic include it in the Subtopic table.

By the way should you not have only 1 table for Subtopic, including a field that indicates the level 1,2,3 etc.