Hi All
Wanting to pick your knowledge before ploughing head first and wasting a load of time 
I have the requirement from work to build a online Audit tool for internal uses, with Covid etc is has become apparent that we need to move from a paper based environment to a paperless.
I have a long, long list of questions, these are broken down into area, then sub area and finally the question itself. A question might need a text answer, a photo uploading or to make things easier i might need to provide a drop down list to select from.
I think i have cracked this part, i have setup a thing which has the question, what response type etc etc.
Now comes the part of actually filling in the form, due to the large number of questions, one or more people could be filling in the questions.
I am thinking that this approach can work (not sure if it is the best approach though)
Thing: - Audit Question
Thing: - Audit Answer
Thing: - Store
On a page i have a repeating group which contains a list of all the questions along with a button to “Start the Audit”. From here i am thinking of trying to create a back end workflow that goes down the list of the repeating group and creates a Audit Answer for each Audit Question.
Is this the best approach?, i will only be adding the Audit Question and the Store to the newly created audit answer. This i think will then allow me to then use workflow to update the records when the answer is created.
Other option would be to create a new audit answer every time a question is answered, thinking for performance issues it would slow things down to so this.
Any guidance appreciated
Thanks
