C
CW
We have a typical customer satisfaction form that has 8 questions, each of
which can be rated in 4 ways: Poor, Satisfactory, Good or Excellent, and the
customer simply checks one option for each question and returns the form.
For each job in our database we want to be able to replicate that form (or
rather, the responses) and then do a query or report to analyse these.
I can see that using an Option Group is one way of providing an on-line
form, and the design of that isn't an issue for me.
What I don't know, however, is whether I need to create some sort of table
to support this, or whether Option Groups have their own way of storing info.
And then, how do I find the entries that have been made, to collate them and
produce a query or report?
Will be very grateful if someone can suggest the best way to go about this!
Many thanks
CW
which can be rated in 4 ways: Poor, Satisfactory, Good or Excellent, and the
customer simply checks one option for each question and returns the form.
For each job in our database we want to be able to replicate that form (or
rather, the responses) and then do a query or report to analyse these.
I can see that using an Option Group is one way of providing an on-line
form, and the design of that isn't an issue for me.
What I don't know, however, is whether I need to create some sort of table
to support this, or whether Option Groups have their own way of storing info.
And then, how do I find the entries that have been made, to collate them and
produce a query or report?
Will be very grateful if someone can suggest the best way to go about this!
Many thanks
CW