K
kris
Hello--
I am new to access and creating a database to store audit results from about
10 different types of audits. Instead of creating a new table to store the
info from each audit, I am trying to create an audit questions table and an
audit answer table. The questions table has a question and question ID
field. The answer table has a field for question ID, its answer, and the
audit type ID (so I will know which type of the 10 it corresponds to).
Anyway--I am having trouble creating the forms. For one audit, there are 3
questions and I cannot get each subsequent question to move to the next
record in the audit answer table and I am curious how I can get that answer
to autopopulate the audit type ID. I hope I am using the correct terms in
this question and given enough info.
I am new to access and creating a database to store audit results from about
10 different types of audits. Instead of creating a new table to store the
info from each audit, I am trying to create an audit questions table and an
audit answer table. The questions table has a question and question ID
field. The answer table has a field for question ID, its answer, and the
audit type ID (so I will know which type of the 10 it corresponds to).
Anyway--I am having trouble creating the forms. For one audit, there are 3
questions and I cannot get each subsequent question to move to the next
record in the audit answer table and I am curious how I can get that answer
to autopopulate the audit type ID. I hope I am using the correct terms in
this question and given enough info.