I want the compare the possibilities of implementing the solution.
I want to make an update to inspection table, let’s name it “Audit”. The Audit contains some columns defined for it, but also list/set of Checks with 4 states (n/a, passed, failed, planned). Each Audit record could have different set of Checks and it should be easy to choose.
Checks are defined in another table and grouped into categories (Category column). The way users may choose sets or particular checks should be based on Category.
I was thinking of defining Form with dropdown field to choose category and basing on the choice have (just below) the list of Checks available to choose further (Allow multiple choice). Each Check should be stored as separated record with its status, date etc and stored in the Audit table.
Any hints on how to?