OK. I have a table with inspectors names in it and on one of the forms I have a drop down list to select the name of the person who did the inspection. So far so good. However, from time to time inspectors leave but the buildings they inspected don't. I want to have the building form still display the name of the inspector who did the inspection, in the collapsed drop down, whether he is still with the department or not. But the user should only be able to choose an inpector for a new job who is active (there is a flag in the inspectors table stating whether or not he is active). The user should not be able to type in a name - hence the drop down LIST. Ideas on the best way to accomplish this gratefully received. TIA.
***************************
Bruce Gilmour
"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein