Yes, I suppose the title is not very clear. Let me explain my problem.
I want an app to map the processes in the company.
So I have type of process (core, support, management).
Then I have another table which is for macroprocesses. It belongs to the Type of Process table.
Then I have a table to processes… it belongs to Macroprocesses table (because a Macroprocess can have several processes, but each process belongs to a single macroprocess)
Then SubProcesses Level 1 and SubProcesses Level 2.
The problem is that when I reach the Process Level, all the other levels below have the same fields.
Process Owner, Main Department, Version, Date Modified, subtable for Processes Inputs and another for Outputs, Diagram Image, subtable for Documents related to that process, etc.
It seems counter productive to have three tables (Processes, SubProcess L1 and SubProcessL2, all repeating some 20 different fields.
Is there anyway to have like 3 different fields for those Tables, and then the other 17 fields show below, seamlessly?
(ps, I guess I could have a single Process Table and then choose the Process Level instead of a table for each level… but I created different tables for this ownership relation… a Process can have multiple subprocesses level 1… a subprocess level 1 can have multiple subprocesses level 2…)