How to make this relationship?

Posts   
 
    
mikeg22
User
Posts: 411
Joined: 30-Jun-2005
# Posted on: 09-Feb-2006 21:17:45   

Say I have TableA that is 1:N with TableB, and TableB is 1:N with TableC. How do I make a TableA:TableC relation using the designer?

The reason is that I want TableAEntity to have a TableCEntity collection...

bclubb
User
Posts: 934
Joined: 12-Feb-2004
# Posted on: 10-Feb-2006 04:13:33   

I don't believe that you can set this relation up in the designer, but you could use a prefetch path to fill TableA.TableB.TableC when you perform a search, or define a relationpredicatebucket for querying TableC that uses criteria from table A.