Not sure I agree with the approach, but maybe I'm not understanding your post. Here's my take on this phase:
- the form header should hold everything pertaining to the audit that would not change regardless of what clauses are being audited (date, auditee, location, auditor(s) etc.)
- the subform would be below that and already contain the clauses for entering findings, complete with the requirement.
- these clauses would have been set up by a different process (a similar form for building the audit plan).
- you'd enter the findings beside the requirement for each clause/sub-clause record
You seem to be compiling the clause selection at the time of entering findings, which suggests you have built the audit using some other tool like Word and are using the db to store findings. Why not do it all in the db?
Thanks for your reply. The audit was originally a word document however it had multiple sections with repeat information and I am in the process of trying to streamline it.
The breakdown of our internal audit system is this:
Our QMS sections contain clauses from 2 different standards (totaling 500+ clauses altogether, but none are cross referenced in different sections)
Each section is audited at least once per year by different auditors
Each audit has to list the clauses with whether or not each individual one conforms and have attached evidence, but some evidence can cover more than one clause
The non-conformances are then added to a separate table where a corrective action, root cause and person responsible is added
So far I have separate pre-filled tables with linking IDs for clauses, sections, audit information, standards and auditor information to avoid repeat information being added for each audit, then an empty table to record conformance/non-conformance with evidence
What I'm interpreting from your suggestion is that each audit should have a table with the clauses pre-entered? Surely where a section is audited more than once it would defeat the point of using access over excel if the clause information is just going to be repeated? I don't know if we're just misunderstanding each other..