AnsweredAssumed Answered

Table Occurrences

Question asked by KhineOo_1 on Aug 27, 2012
Latest reply on Aug 27, 2012 by philmodjunk


Table Occurrences



Before I ask my question :), I would like to give a scenario of my database.

It has three tables

(1) Main Company

(2) Subsidiaries

(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.