I hope this will make some sense.
I have a bound textbox called techNum in which the user can enter any 4 digit number that corresponds to one of our technicians numbers. I also have an unbound label called FSM, which will hold the name of their manager, but this label will need to be read only yet change based upon what the user enters in the techNum field.
I have two lookup tables that I am referencing here.
techTbl
[techNum],[techName],[fsm_Id],[longTechNum]
-AND-
fsmTbl
[fsm_id],[fsmName],[longFSMID]
So, on the form, when a user enters say, 2900, for the tech number I want that number to be looked up on the techTbl, find the fsm_Id, then return the fsmName associated with that fsm_Id on the fsmTbl. I want the returned fsmName to be posted in the aforementioned unbound label.
How can I do this? For some reason when I list it out like that it sounds more complicated that I think that it should.
Mike