General information
Title:
Another Datarelation Question
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only