"An RCMP officer (Corporal X) was ordered to resign or face dismissal for having an intimate relationship with a confidential informant. The relationship compromised the integrity of an active criminal investigation and misled the court. The conduct board decision emphasized that such misconduct erodes public trust in the justice system."