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
Hi Bob,
Thanks for the link. I will have a try. Do you have an opinion about inner join? I see that somebody does not like that.
Is this a feature F7 may have in the future?
Regards
Bojum01
Thanks for the link. I will have a try. Do you have an opinion about inner join? I see that somebody does not like that.
Is this a feature F7 may have in the future?
Regards
Bojum01
You need to login to be able to post a reply.
