I'm building a database to carry out a process called (P)FMEA - a quality procedure in the automotive industry.
Within an (P)FMEA, you look at possible problems in a process and break them down into possible causes and possible solutions, so I have ended up with a data structure to match this, i.e. a string of 5 one-to-many relationships:
A Process (tblProcess) contains many Steps (tblFMEAProcessSteps).
A Step contains many Requirements (tblFMEARequirements).
A Requirement contains many Potential Failure Modes (tbFMEAlPotentialFailureModes).
A Potential Failure Mode contains many Potential Causes (tblFMEAPotentialCauses).
A Potential Cause contains many Recommended Actions (tblFMEARecommendedActions).
When working in Excel, in the Process column, you combine the cells to match the row with its corresponding Steps and so on through the relationship, so that if you have 30 recommended actions related to a Process, the cell with the Process in is 30 rows.
Is there a way to do this in a form? If not, is there another way to do this?
Ideally, I would have multiple layers of sub-forms to achieve this, but you cannot have a subform in a subform, so I cannot achieve it that way.