Before I ask my question :), I would like to give a scenario of my database.
It has three tables
(1) Main Company
(3) Key Processes
Main Company and Subsidiaries have a relationship through the Main Company ID.
Main Company and Key Processes have a relationship through Main Company ID.
Subsidiaries and a second occurence of Key Processes (Key Processes 2) have a relationship through Subsidiary ID.
Is there any way to have a layout that shows all Key Processess from both occurrences? or Have a portal showing information from both table occurrences?
The idea is that I would want to show ALL processes under Main Company to include the Subsidiaries own as well.