Qrew LegendThis would be best done with a structure where the user Creates a parent Daily Facility Audit record to select the facility/area from a drop down list and enters the date (which can be set to default to Today).
Then you would have a child table of Daily Audit Questions.
You would also have a Master Table of Master Audit Questions in a relationship where One Facility/Area has Many Master Audit Questions.
When the User saves the Daily Facility Audit and it has no child records, you would initiate a Pipeline to search the table of Master Audit Questions and then in the for Each Loop you would add a record to the child table for Daily Audit Questions.
The format of the questions will need to either be identical or possibly say two or three formats which would be controlled on the form by a form rule.
I don't know what your questions look like now but for example you could start with a template where it's a yes no or pass fail type multiple-choice response and then a freeform open Comment field.
The user would have the choice to use Grid Edit to answer the questions or they might view the first record on the embedded report and save and next their through the children.
