Hi everyone, I remember Rick doing a Tech Help on a combobox, i think was in orders/invoices for account managers, where one of the WHERE conditions is IsActive = True.  And if the employee left the business, and if IsActive was set to false, they no longer appear in the combobox.  
But there was an issue if IsActive is false, the previous orders for that person no longer showed that person's details. There was a Silver Member's work around for this, but i cannot find the Tech Help this was on! if anyone could point me in the right direction that would be much appreciated.