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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Design

Author  Topic 

supersql
Yak Posting Veteran

99 Posts

Posted - 2005-09-21 : 13:07:05
Can I have a relation betwen tables in this way.
TableA - TableB
TableA - TableC
TableA - TableD

TableB - TableC
TableB - TableD
I am generating unique IDENTITY for each table and trying to connect in this way.
My doubt is if I have relationship as in 1st scenario,do I need to have second scenario.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-09-21 : 13:09:51
I don't understand the relations to the tables. Posting the table names doesn't help us help you. We need to see the table structures and the proposed relations on the columns.

Tara
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-09-21 : 13:50:45
Don't You just need;
A -< B
B -< C
B -< D

Or post more info on what You are modeling.
Go to Top of Page
   

- Advertisement -