assignment

[Pietro]

Hi,
I have a form called assignment,this form contains 4 unbound controls:
agent (combobox),sort(combobox),cases,language(combobox).
I want to use this form to assign a certain number of cases to the agent
selected in the agent combobox..
I want to put a certain number in the control "cases" so when i run the
update query i may be able to control the number of cases assigned to each
agent.

 

[Olduke]

Pietro:
It would probably be a lot easier if you did this function the other way
around.
Create a form or report that shows how many assignments each agent is
currently working on and assign it using that.
Just a thought.