List A is a list of employees with contact information and a column that indicates if the person is still active. List B is a list of projects assigend to employees using a lookup field to select the employee from List A.
If the employee is no longer active, I don't want the project showing up in the list. How can I do this?
FYI I am using SP2007 and do not have SP Designer.