Portal, Audit Solution

Discussion created by jarrodjb on Sep 28, 2017
Latest reply on Sep 28, 2017 by philmodjunk

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.