Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Another Datarelation Question
Message
From
22/07/2003 10:24:32
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
 
 
To
All
General information
Forum:
ASP.NET
Category:
ADO.NET
Title:
Another Datarelation Question
Miscellaneous
Thread ID:
00812359
Message ID:
00812359
Views:
58
I am unsure on how to retrieve data from tables 2 tables
that are related through a relationship table....

This seems to confuse me...!

TableOne
--------
TableOneID
TableOneDesc

TableTwo
--------
TableTwoID
TableTwoDesc


TableOne_TableTwo_Relationship
------------------------------
TableOne_TableTwo_RelID
TableOneID
TableTwoID

I have related TableOne to TableOne_TableTwo_Relationship.
Then I have related TableTwo to
TableOne_TableTwo_Relationship.

I am unsure on how to traverse though the set
relationships to retrieve data. ie) I want to print out
all TableTwoDesc that have been related to a specific
TableOneID.

Thanks for your help,

Alvin
Next
Reply
Map
View

Click here to load this message in the networking platform