Help for app structure to achieve my goal

data
references
(Charles B) #1

Hi, I want to develop an app that audits different audit topics. In the main view, I have 6 different subjects see image1. From this table, I want to go in the audit topic table and from there I want to have multiple forms to fill to complete the selected audit topic. I want to do this for each audit topic and forms are all different Y-N-N/A field type questions. How should I structure my table and references between them to achieve this app design without turning around?

Image 1:

Here’s what my data table looks like so far…

Table [Audit] fields (refering to image1):
|AuditID|Name|Description|Image|

Table form1 [Audit_Cadenassage] (first topic)
|KeyID|Timestamp|AduitID|Result|Signature|188.2.|188.2.1|188.2.2|188.3.|188.4.|188.4.1|188.4.2|188.4.3|188.4.4|188.4.note1|188.4.note2|188.5.|188.6.|188.6.1|188.6.2|188.6.3|188.6.4|188.6.5|188.6.6|188.6.7|188.6.8|188.7.|188.7.1|188.7.2|188.7.3|188.7.4|188.7.5|188.8.|188.9.|188.10.|188.11.|188.11.1|188.11.2|188.11.3|188.11.4|188.11.5|188.12.|188.13.|

Should I separate the forms in a nested form type?