Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Database Design and Application Architecture  Tiered or 'cascading' data storage

Author  Topic  jeffcj Starting Member 2 Posts Posted - 2009-03-26 : 13:13:56 I have a quick design question.. I have designed an application that the users use to log questions received. Each question has a reason and a subreason. At the moment there are three tables. a "reason" table, a "subreason" table and a "reason_subreason_assoc" table that holds the associations. Example reason 1 'Main reason' subreason 1 'Sub reason 1' 2 'Sub reason 2' association table 1 1 1 2 Now I have been asked to add a third level. That has me rethinking this approach. Thoughts? I appreciate any assistance! Jeff