Hello FM folks
Working on a solution for mobile auditing.
Pretty basic but i seem to have hit a wall or not thinking clearly.
2 tables Header and Violations
Header contains the who what where and when and uID fields. 1 Audit is 1 record in header
Violations contains 108 records of violations, type, category pass/fail and i assigned a ViolationID as well.
Ideally to keep it simple i want auditors to be able to create a new record in header and have a new fresh set of the 108 possible violations available to them via a portal.
I think I am missing a third table possibly but unsure... Table Audits?
Thanks in advance.
TL:DR new record needs new set of 108 possible violations available.