Hello All,
I've been lurking around the last few days trying to get a couple questions answered and it seems like survey db's are the most difficult and challenging to get right. I believe I have a good layout and have been able to hammer down most of my db, but I'm missing the last couple pieces to finish this thing up and get it into production. A quick rundown:
I have the following tables:
tbl_Customer_Service_Survey
tbl_Employees
tbl_Managers
tbl_Grade_Values
tbl_Property_List
tbl_Response_Values
tbl_Survey_Questions_CSR
tbl_Survey_Questions_Tech
I've created two forms, one for CSR and one for Tech and have them in a tabbed form for the manager giving the out-bound survey calls to use. All the information collected from the survey form is placed into tbl_Customer_Service_Survey for both CSR and Tech surveys. My questions are these:
What is the best way to have the Questions from the respective table be pre-populated into the form?
I've had a hard time getting the final grade assigned to the survey score. tbl_Grade_Values has the following:
I gave min and max range for averaging scores from the survey's per employee and regions.
Grade MaxValue MinValue F- 50 50 F 49.99 42 F+ 41.99 41 D- 40.99 40 D 39.99 34 D+ 33.99 33 C- 32.99 32 C 31.99 27 C+ 26.99 26 B- 25.99 25 B 24.99 19 B+ 18.99 18 A- 17.99 17 A 16.99 11 A+ 10.99 10
If any other information is needed I'll supply as quickly as possible. Thanks in advance for the assistance!
TK