jarrodjb

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.

 

-J

Outcomes