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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-03 : 13:36:12
|
| Ian writes "Hi,I am having a problem with designing a database. I have a Branches table which is related to a SubBranch and then a Unit table which is related to the SubBranch table, easy enough.Now, I have a Reports Table and a Manuals table. Any manual or report can belong to either a Branch, aSubBranch or a Unit. The easist way I can see to arrange it is to have a seperate report table for each Level, but this doesn't seem normal. So, how do I relate the three branch tables to the reports and manuals table?I am using Win2000 and SQL 2000Many Thanks" |
|
|
|
|
|
Multiple Tables Related To Multiple Tables