Hi to all.
Little introduction on what I'm trying to do:
I'm in charge of creating an access database for our supervisor where
they can grade their agents.
Per ex: agents are talking to customers and the supervisor is
listening to their conversation (and grading them as per a specific
template)
What I've done so far:
Created Tables for the entry of:
List of TM, list of Agents and list of quality grid template (which
contains categories, sub-categories,sub-sub-categories and a choice of
grades)
I've created a blanked table called Qual_DB which receives the entrys.
The Qual_DB had a PK called DBID
I've created a Form where they can choose
The day (which dumps the selected day in the Qual_DB.DateSelect)
Supervisor name (which dumps the selected name in the
Qual_DB.TMSelect)
Agent's name(which dumps the selected name in the Qual_DB.AgentSelect)
The quality grid template (which dumps the selected qualityID in the
Qual_DB.QualID)
Then I got a SubForm (link master field is the QualID of the form and
QualID of the subform) formated as Datasheet which contains the
categories, sub-categories (both are "text box" reprenting the
categories and categories names) then I got a "list box" where they
can choose a grades (ie:Y,N which represent the grade value 10,0 for a
specific categories. Another categories would have Y,N with the value
2,0)
So each categories got a specific grading.
The problem is here:
If I try to choose a grade, it gives me "This recordset is not
updatable".
I think this is due to the fact that access doesn't know in which
Qual_DB.DBID the grade should go in.
Here's what I mean:
After the TM chooses the date, tm name, agent name and quality grid
type, I got in Qual_DB:
Qual_DB.DBID with value of 1
Qual_DB.Dateselect 09/05/2008
Qual_DB.TMSelect with value of Alex
Qual_DB.AgentSelect with value of Fred
Qual_DB.QualID with value of 2
Qual_DB.GradeID with null value (since the TM didn't choose the grade
yet)
Then in the SubForm, I got a DataSheet with the list of all categories
(Text Box), sub-categories (Text Box) and grade (List Box).
Here's an example of what shows in the DataSheet:
categories sub-categories sub-sub
categories Grade
Call structure Open call Assure you can
help
Call structure Open call Greet, Brand,
Announce name
Call structure Open call Validation (3
quand requis)
Call structure Fulfill the client's request Clarify/Ask
appropriate questions (fact finding)
Call structure Fulfill the client's request Ensure client
satisfaction/comprehension
Call structure Fulfill the client's request Promote self-serve
Call structure Fulfill the client's request Provide clear,
accurate and complete information
Call structure Fulfill the client's request Resolve the request
Call structure Tools and Processes B-expressymo/Max+ ticket
entry
Call structure Tools and Processes Use of tools & follows
process/procedures
Call structure Recap & close call Appreciate client's chat
or business/loyalty & brand Bell
Call structure Recap & close call Recap the call with the
client & accurate note entry
Soft-skills Choose your words Choose your
words
Soft-skills Adapt to your client Adapt to
your client
So how access knows to which Qual_DB.DBID the grade is going to.
The way I would like it to work is: They choose a Grade (which is
linked to the sub-sub categories) and on the event lost focus, it
would take the date, tm, agent, quality type,sub-sub categories, grade
and would create a new recordset.
I hope my question is clear loll!!.
thank for any help you guys could give me.