Are you using a drop down list or pop up menu?
With a drop down list, you can place a name field from the related table on top of the drop down list but with Behavior settings specified that denies Browse Mode access. You click on the visible name field and the drop down list hidden behind it pops to the front and deploys.
If you use that method, the Name field can be referenced via a relationship to a different Occurrence of the same table and then that relationship need not include the specified status as part of its relationship.
I am using a popup menu. I assume there is no solution using a popup menu?
There's no way to get the pop up menu to show a name that is no longer part of the value list. There might be ways to hide the pop up behind an invisible tab panel such that one tab panel shows the same related name field that I described while the other shows the pop up menu. An OnRecordLoad script trigger could check the status of the selected employee and if they are no longer active, use Go to Object to pop the panel with the name field up to conceal the now nonfunctional pop up menu...
Worked like a charm, I had no idea you could drop a field on top of another that uses a popup menu and make it work like you described. I simply put a Table2::NameField (denied field entry in browse mode) on top of the popup menu field (Table2::Employee). So now it always displays a name and hides the field containing Table1::_pkPersonnelID. I think the trick here is that I have a OnOnjectSave script trigger that sets the _fkPersonnelID in table 2 (which the layout is based off of with data from Table1::_pkPersonnelID. I didn't have to change my popup menu for a dropdown either. Works on Win so far, hope I get the same behavior on a Mac.