I am building a database that is used for tracking audit results. I currently have the following tables:
tblAuditType
>idAuditType - UID
>txtAuditType - Description
tblAuditCategory
>idAuditCategory - UID
>txtAuditCategory - Description
>idAuditType - int(lookup tblAuditType)
tblAuditQuestions
>idAuditQuestion - UID
>mmoQuestion - Questions regarding Audit
>idAuditCategory - int(lookup tblAuditCategory)
tblAuditResponse
>idAuditResponse - UID
>txtAuditResponse - Description
tblAudit - this table holds higher level audit details
>idAudit - UID
>idAuditType - int(lookup tblAuditType)
>dtmAudit - Date
tblAuditDetail - this table holds the audit detail questions and user responses from the form I have created. it is linked to the tblAudit form through idAudit
>idAuditDetail - UID
>idAudit - int(controlled by tblAudit)
>idAuditQuestion - int(lookup tblAuditQuestion)
>idResponse - int(lookup tblAuditResponse)
-----
I am having issues with developing a form that will enable a user to click through a series of questions and make their responses without having to actually select the questions themselves. What I would like to accomplish is have my form open and display the questions that are available per each audit type. The user should be able to enter the responses after reading the question and move on to the next question without having to actually select the next question from the drop down list. If anyone has any input on how I might be able to do this I would appreciate it. Thanks for your help!
tblAuditType
>idAuditType - UID
>txtAuditType - Description
tblAuditCategory
>idAuditCategory - UID
>txtAuditCategory - Description
>idAuditType - int(lookup tblAuditType)
tblAuditQuestions
>idAuditQuestion - UID
>mmoQuestion - Questions regarding Audit
>idAuditCategory - int(lookup tblAuditCategory)
tblAuditResponse
>idAuditResponse - UID
>txtAuditResponse - Description
tblAudit - this table holds higher level audit details
>idAudit - UID
>idAuditType - int(lookup tblAuditType)
>dtmAudit - Date
tblAuditDetail - this table holds the audit detail questions and user responses from the form I have created. it is linked to the tblAudit form through idAudit
>idAuditDetail - UID
>idAudit - int(controlled by tblAudit)
>idAuditQuestion - int(lookup tblAuditQuestion)
>idResponse - int(lookup tblAuditResponse)
-----
I am having issues with developing a form that will enable a user to click through a series of questions and make their responses without having to actually select the questions themselves. What I would like to accomplish is have my form open and display the questions that are available per each audit type. The user should be able to enter the responses after reading the question and move on to the next question without having to actually select the next question from the drop down list. If anyone has any input on how I might be able to do this I would appreciate it. Thanks for your help!
