T
TAWise
My question is so complicaated to me that I will do my best to detail it. I
am working with Duane Hookum's Survey database and it is working fine. I
have 11 surveys, ~600 questions, and 80 respondants. The survey contains
questions as to employee skills, knowledge, and services they provide. The
key field here is "RespID" and each person that takes the survey could have
as many as 11 RespID's (one for each survey). To this database I have added
a form called "Talent". This form collects responses from one respondent and
with a bar chart displays their "yes" responses to each of the 11 surveys.
This form also shows name, building, etc. for that person. This form is
populated by a field I call "TalentID". There is one TalentID per
respondant's name. My problem is that when a person takes a survey and
establishes a "RespID" for that Survey, I would like for the Talent ID field
in my Talent Form/Table to get populated once by respondant's name and not by
each RespID. How can I link the two together so that even though one person
has several RespID's they only have one TalentID. (I hope I explained my
question well enough!)
am working with Duane Hookum's Survey database and it is working fine. I
have 11 surveys, ~600 questions, and 80 respondants. The survey contains
questions as to employee skills, knowledge, and services they provide. The
key field here is "RespID" and each person that takes the survey could have
as many as 11 RespID's (one for each survey). To this database I have added
a form called "Talent". This form collects responses from one respondent and
with a bar chart displays their "yes" responses to each of the 11 surveys.
This form also shows name, building, etc. for that person. This form is
populated by a field I call "TalentID". There is one TalentID per
respondant's name. My problem is that when a person takes a survey and
establishes a "RespID" for that Survey, I would like for the Talent ID field
in my Talent Form/Table to get populated once by respondant's name and not by
each RespID. How can I link the two together so that even though one person
has several RespID's they only have one TalentID. (I hope I explained my
question well enough!)