Setting CallID to TechID (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=154892