Thanks JohnCCole . I had considered your workaround as well, but was really hoping there was a simpler, more direct solution.

Thanks carl.billings

JohnCCole I had considered just getting HR/Finance to uncheck the Sales Rep checkbox manually at the time of updating the Termination Date field. But that's a good point about the commission payment - perhaps schedule it for a month after termination. Thanks again.