I have information in 4 separate tables: tblProcess, tblCycle, tblFunction, tblCondition,
The relationship between these tables is the following:
- A process can have one or more Cycles. Each Cycle can have one or more Functions. Each Function can have one or more Conditions, etc.
The table for Cycles has two ID's, one is a CycleID, one is a ProcessID (since process is the 'parent' and cycle is the 'child'). similarly, the Function table has two ID fields, one is Function ID, and one is Cycle ID. This is how the references between the 4 levels is setup (process is the higest level, step is the lowest).
I just want to make a basic report to display all the details for one process, then all the details for 2nd process, etc. The report output needs to be:
Process 1
Cycle 1.1
Function 1.1.1
Condition 1.1.1.1
Condition 1.1.1.2
Function 1.1.2
Condition 1.1.2.1
Cycle 1.2
Function 1.2.1
........
Process 2
Cycle 2.1
........and so on.....
How do I set this up? Is it just using the 'sorting and grouping' option?
The relationship between these tables is the following:
- A process can have one or more Cycles. Each Cycle can have one or more Functions. Each Function can have one or more Conditions, etc.
The table for Cycles has two ID's, one is a CycleID, one is a ProcessID (since process is the 'parent' and cycle is the 'child'). similarly, the Function table has two ID fields, one is Function ID, and one is Cycle ID. This is how the references between the 4 levels is setup (process is the higest level, step is the lowest).
I just want to make a basic report to display all the details for one process, then all the details for 2nd process, etc. The report output needs to be:
Process 1
Cycle 1.1
Function 1.1.1
Condition 1.1.1.1
Condition 1.1.1.2
Function 1.1.2
Condition 1.1.2.1
Cycle 1.2
Function 1.2.1
........
Process 2
Cycle 2.1
........and so on.....
How do I set this up? Is it just using the 'sorting and grouping' option?
