>>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.
>
>
>Populate your list box from a select that only selects inspectors where ACTIVE = .T.

Did that but then the inactive inspectors don't show up in the old building records.