AnsweredAssumed Answered

Table Occurrences

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

Title

Table Occurrences

Post

Hello,

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.

 

Thanks.

 

 

Outcomes