Forwarding id call to tech id (1 Viewer)

[syntax]

Hi All,
I have the following tables:
Tbltechnicians (TechID,TechName)
tblCalls(CallID,CallDesc)
tblCalls-technicians(CallID,TechID)

I have frmHandleCalls and I would like to set callID to techID so that the technician would know which calls related to him.

How should I do that?
Should i do it with vb?
10x in advance.

 

[namliam]

Double post http://www.access-programmers.co.uk/forums/showthread.php?t=154893

How / where would you assign the call to a technician?

 

[syntax]

Calls

By form.
When a new call is created, i would like that it will assign to the first technicain which has the lowest amount of calls.

 

[namliam]

The lowest amount of calls does not allways equal the lowest amount of work tho