Hi,
I have a database which in part has three hierarchical tables, say A B and C.
Using relationships I can start with B and join A and B, as well starting with C and join B and C.
I am attempting to link A B and C so as to show the full hierarchical structure. Is this at all possible?
I have tried starting with C, with the relationship to B and then use that join model to create a relationship back to A.
I have tried this in both Advance Forms and Connectivity.
The core data does not have a direct cross reference between A and C, only via B.
Thanks
I have a database which in part has three hierarchical tables, say A B and C.
Using relationships I can start with B and join A and B, as well starting with C and join B and C.
I am attempting to link A B and C so as to show the full hierarchical structure. Is this at all possible?
I have tried starting with C, with the relationship to B and then use that join model to create a relationship back to A.
I have tried this in both Advance Forms and Connectivity.
The core data does not have a direct cross reference between A and C, only via B.
Thanks