B
Brigitte P
I posted a while back regarding normalizing dbase and doing a survey, and I
was directed to look at the AYS2000 design. It took me a while to figure it
all out and adapt my application, but it works fine now. I want to thank you
for sharing your expertise so freely. My database is only doing one survey,
but it is normalized, that is, the questions are records not fields. I
developed many years age surveys (Mental Health Assessments etc) modelled
after an application done by a consultant. Finally, I understand that this
model was not normalized, that is, we had fields, question 1, question 2
....... This worked okay with a few questions but for the nearly 400
questions I have in the latest survey, I had to come up with something else.
Your AYS2000 pointed me in the right directions. While it works, I still
don't know why and how some of the things work, especially the refreshing of
the questions via the append query. But I think I can figure it out so I
know for the future. Thank you again for this help, and past help the
newsgroups provided for me, a sometime developer who doesn't have this as a
main responsiblity.
Brigitte P.
was directed to look at the AYS2000 design. It took me a while to figure it
all out and adapt my application, but it works fine now. I want to thank you
for sharing your expertise so freely. My database is only doing one survey,
but it is normalized, that is, the questions are records not fields. I
developed many years age surveys (Mental Health Assessments etc) modelled
after an application done by a consultant. Finally, I understand that this
model was not normalized, that is, we had fields, question 1, question 2
....... This worked okay with a few questions but for the nearly 400
questions I have in the latest survey, I had to come up with something else.
Your AYS2000 pointed me in the right directions. While it works, I still
don't know why and how some of the things work, especially the refreshing of
the questions via the append query. But I think I can figure it out so I
know for the future. Thank you again for this help, and past help the
newsgroups provided for me, a sometime developer who doesn't have this as a
main responsiblity.
Brigitte P.