Thanks for the quick feedback. I am reading through help info now.
If I am understanding you correctly I will need two tables. One for Audits and one for questions. I am not sure what you mean by "set up a series of Standard Template Audits which would hold the correct child records (the audit questions) fort each type of Audit."
Would the audits table have one field with a multiple choice field for different audits and then the questions field have text fields and multiple choice fields for the question text and compliance selection respectively?
I get the concept, but am struggling to understand the architecture.